On 2 Apr 2012, at 9:58pm, Alexey Pechnikov <pechni...@mobigroup.ru> wrote:
> Description: Unicode string library for C > The 'libunistring' library implements Unicode strings (in the UTF-8, > UTF-16, and UTF-32 encodings), together with functions for > Unicode characters (character names, classifications, properties) and > functions for string processing (formatted output, width, word > breaks, line breaks, normalization, case folding, regular expressions). Trying to figure out what SQLite would want from Unicode characters I don't end up with any of those. I think all it wants is sorting, so SQLite can make an index properly. And I don't really care whether it's case-sensitive or not since my software can do case conversion on input. Because they're in standard functions, string length and substring substitution would be nice but I can live without them working properly. One problem is that, as someone explained to me last year, sorting of unicode characters depends on which language you're using (and other things if you're fussy). So for every index you make you'd have to declare the language, and SQLite would have to store it. I was trying to figure out whether SQLite could make use of the OS's unicode library (using different compilation directives for each platform which supports unicode) but I'm only really familiar with the Mac operating system and I don't know how Windows or Linux does these things. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users