On Mar 15, 2007, at 9:19 AM, 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?
You can define a column to not be case sensitive at table creation time http://sqlite.org/datatype3.html#collation However, I dont think you can do this in the IDE but need to use code to access this capability While there is a way to use a user defined collating sequence I don't think this is accessible via the REAL SQL Database but may be if you use Marco's SQLite Plugin Pro which exposes a different API available in the SQLite engine _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
