> -----Original Message----- > From: Michael Hunley [mailto:[EMAIL PROTECTED] > > Solution 1: implement your own OrderBy function and call that instead > Solution 2: Implement a Flatten function that converts > accented characters > to their non-accented and, optionally, converts all uppercase > to lower (or > vice-versa). Then use ORDER BY FLATTEN(Name)
Unfortunately, in neither of these cases will SQLite use an index to perform the sort or retrieval. So you won't get the performance of, say, mysql's text fields: http://www.mysql.com/doc/en/CHAR.html -Ken --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
