On 3/15/07, Norman Palardy <[EMAIL PROTECTED]> wrote: > > 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
Thanks Norman. I found a reference to that shortly after posting my original message and it works great (I'm using it with a select statement, not in creating the tables). For anybody interested who doesn't want to look it up, the syntax is: "SELECT * FROM myTable ORDER BY fieldName COLLATION NOCASE" _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
