At 8:19 AM -0700 15/3/07, Dennis Birch wrote: >The REALSQLDatabase appears to use case-sensitive sorting when >applying its ORDER BY clause to a SELECT statement. I'd like to be >able to change it to non-case-sensitive. > >The documentation on SQLite.org refers to a COLLATION setting which >can be applied to a database or to separate tables for use with ORDER >BY clauses as well as in other applications. But I don't see any >specifics on applying that. Is it possible to do that, or something >else with a REALSQLDatabase to change the default sorting behavior?
AS Norman says, either it is in the SQL as 'COLLATE NOCASE' or the CREATE TABLE call There is no global switch like Sybase So if the tables are create you need to add the eg select firstname from people order by firstname COLLATE NOCASE -- Cheers, Dr Gerard Hammond MacSOS Solutions _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
