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? _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
