On 3/19/07, Juha Metsäkallas <[EMAIL PROTECTED]> wrote: > 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).
Has anybody dealt with this issue with REALSQLDatabase? This seems like a rather important issue. _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
