Is there any chance of getting an international-aware case-insensitive collation option put into the core language, at least as a compilation option? Seems that if SQLite is so focused on UTF data and so many users are international, the limitation of available options being English A-Z comparison is not appropriate.
One of the problems I have with custom collations is that they are only available in the environment where the custom collation is defined. We create our database with the SQLite.NET wrapper and if we provide a custom collation we can not then open then the database using the command line tool due to "no such collation sequence" error. A less useful but possible alternative would be to have an option to ignore custom collation sequences on a connection or just within the command line tool. Thanks, Sam ------------------------------------------- Were Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -----Original Message----- From: jp [mailto:[EMAIL PROTECTED] Sent: Saturday, March 10, 2007 9:52 AM To: sqlite-users@sqlite.org Subject: [sqlite] collate function / international sort on linux Thanks to several posts in this forum, I now have a custom collation defined with sqlite3_create_collation, which uses Window's CompareStringA. I managed to add it to main.c and recompiled sqlite (I finally got my compilation running on Windows with MingW/Msys). For my needs properly does case-insensitive and characters with diacritics sorts. For example: AAA amigo ándale Andalucía ángel Azul Now I need to have this function, CompareStringA or similar/better, on linux. Does anybody have it or can point me where to look for it? jp ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------