Hello Note, that UPPER works only for 7-bit Latin characters. I'm also afraid that SQLite's collation NOCASE is only for 7-bit Latin characters. I.e. defining a collation or using UPPER doesn't work with e.g. Latin-1 or UTF-8. (http://www.sqlite.org/lang_expr.html)
IIUC, SQLite lacks language defining collations (e.g. COLLATION "de_DE"), you have to provide you own case-insensitive sorting for other character sets. I'm not familiar with SQLite but in other databases this can be accomplished by triggers or host language (Realbasic in this case). HTH, Metsis _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
