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 ____________________________________________________________________________________ It's here! Your new message! Get new email alerts with the free Yahoo! Toolbar. http://tools.search.yahoo.com/toolbar/features/mail/ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------