On 8/4/06, Cory Nelson <[EMAIL PROTECTED]> wrote:
IE, using memcmp() to compare strings. I've been bitten by this before, with SQLite producing unexpected results when using UTF-8. Using UTF-16 has worked more reliably in my experience.
SQLite only knows how to sort ASCII, so memcmp does that right (being it UTF-8 or UTF-16). If you think about it, the only way sorting will work 100% is by having some form of localization (because for each language different sorting rules apply, _even_ for words composed only of ASCII characters). Adding localization to SQLite is out of the question (it would probably need a library as big as SQLite itself), so it's up to the user to define it's own localization funtions and integrate them with sqlite (there are all the necessary hooks ready for that). Regards, ~Nuno Lucas
