Hi there, i need to be able to sort results from a select statement in alphabetic order. The results however can have diacritic characters, like the german Umlaute "Ä,Ö,Ü"). They are supposed to be sorted like "AE", "OE" and "UE".
I have been pointed to ICU as the solution. I got a download link to a compiled DLL of the ICU project, as I couldn?t figure out how to compile my own version, yet the DLL i got did not load right as an sqlite3 extension. Can anyone help me please? I am using the latest sqlite3 (command line version) on Windows XP SP3. Ideally, I?d like to get precompiled binaries, but any help on how to compile the ICU extension in a workable fashion would be much appreciated as well. Thanks, -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users