On Fri, 2007-06-22 at 18:57 +0200, Jiri Hajek wrote: > Hello, > > I wonder whether there are any plans to include internally proper > Unicode comparisons? Don't get me wrong, I think that it's great that > SQLite supports custom collations, there's absolutely no problem to > handle it in internally for my database, but problem is that if I > define UNICODE collation, no other application knows about it and so > users can't open it in any SQLite DB editor. > > Nowadays applications without Unicode support slowly become rare, as I > see, I'm not the first one asking for this kind of support in SQLite. > Is there any technical reason why not to include UNICODE and e.g. > IUNICODE (for case-insensitive comparisons) collations in SQLite? Is > it because of some systems that don't have (full) Unicode support? In > such a case, I guess that it could be a compile-time option.
The reason is as you've surmised. Not all systems have full unicode support (I'm not sure, but if I had to guess, I would say very few systems do). Including an implementation with SQLite would bloat the library to at least several times it's current size. Another reason is that it's a pretty complex topic. Supporting most European languages would probably be possible without too much trouble, but once you get into Asian and Middle-eastern languages I think it's much harder. There is an extension packaged with SQLite sources that uses the ICU library to provide locale dependent collation sequences and case folding. See here for details: http://www.sqlite.org/cvstrac/fileview?f=sqlite/ext/icu/README.txt Dan. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------