I am unable to reproduce this problem. Using the script below, with RMNOCASE changed to just NOCASE, everything works fine on the SQLite command-line shell on the website on Linux. I also tried various other versions of SQLite with the same result.
On Jan 21, 2010, at 8:00 AM, Hub Dog wrote: > I hava a table. The table schema is > > CREATE TABLE AddressTable > ( > AddressID INTEGER PRIMARY KEY , > AddressType INTEGER , > Name TEXT COLLATE RMNOCASE , > Street1 TEXT , > Street2 TEXT , > City TEXT , > State TEXT , > Zip TEXT , > Country TEXT , > Phone1 TEXT , > Phone2 TEXT , > Fax TEXT , > Email TEXT , > URL TEXT , > Latitude INTEGER , > Longitude INTEGER , > Note BLOB > ) ;. > > if I execute following sql to query data , the sqlite 3.6.22 command > line > downloaded from www.sqlite.org will crash. > > SELECT > Adr.Name COLLATE NOCASE AS AddressName > FROM > AddressTable AS Adr > WHERE > Adr.Name LIKE '%_'. > > if I change the Adr.Name to AddressName , the sql execute result is > ok. > > SELECT > Adr.Name COLLATE NOCASE AS AddressName > FROM > AddressTable AS Adr > WHERE > AddressName LIKE '%_' ; > > it seems the crash was related with the collate RMNOCASE of > AddressTable > table's field Name. > in default sqlite command line, there is no rmnocase collation. so I > mapped > it to the default nocase collation. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users