I can confirm that the crash problem has been fixed by http://www.sqlite.org/src/info/1258875e07 checked-in . Now executing following sql will report no such collation sequence: RMNOCASE instead of crash.
SELECT Surname || ', ' || Given COLLATE NOCASE AS Person , Adr.Name COLLATE NOCASE AS AddressName , Adr.Street1 , Adr.Street2 , Adr.City , Adr.State FROM NameTable AS Nam , AddressLinkTable AS Lnk , AddressTable AS Adr WHERE Nam.OwnerID = Lnk.OwnerID AND Lnk.AddressID = Adr.AddressID AND Adr.AddressType = 0 AND Adr.Name LIKE '%_' /* Error message: no such collation sequence: RMNOCASE */ Thanks Chinshou _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users