> > > > 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 >
Another solution that would allow using an index would be to add another column, flatname, and insert the name into that column without any accents while still inserting the real name with accents into a different column, then do an order by on that flatname column. This will allow you to order it and still retain your indices, at the cost of an extra column. Jay Macaulay --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]