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]
-----------------------------------------------------------------------------

Reply via email to