On 12/03/2009, at 12:36 PM, Jean-Christophe Deschamps wrote:
>
> To answer another post by Ian, yes I've had a look at ICU.  Of course
> ICU knows about its size, but what can they do about it, since their
> goal is to implement the most complete support possible?

Make parts of it be possible to factor out.  I've seen many 'complete'  
software packages that could have all the bits you don't need simply  
turned off and removed.

> And again,
> that's a very good thing. But my reluctance is elsewhere: I do not
> adhere that much in locales. I use more than a strictly defined locale
> "locale" and less than a world locale!

I'm not sure what you mean by this.  But I do know that 'locale' is  
important.  Even with the same set of characters two different locales  
will use two different orderings for the exact same set of  
characters.  And yes, I'm referring to Western Europe locales here.

>
> Also, yes I write most users. BTW SQLite would possibly have more
> "rest-of-the-world" fans if a more simple handling of diacritics were
> available!  Look: we in Western Europe have been computerized in ALL
> PURE ASCII CAPITALS for many years. Then in mixed casing, but always
> ASCII. Now is perhaps the time for something else.

Well, I may be a Ascii speaker, but the company I work for was founded  
in Norway and bought by a company in Finland with most of its software  
originally being used in Germany.  I use diacritics enough that I know  
how to type them by memory.  My own work as part of all this for a few  
years had most of its customers in China. Which is all to say: I  
always find it funny how some non-Americans talk about how centric the  
American point of view is and then seem to forget just how many people  
are not from Western Europe either.  Western Europe < (rest-of-world/2)

If fast localization is that important to you perhaps use Mimer  
instead?  Its collation is pretty good, it also (in my own tests) only  
a little slower and a little larger than SQLite.  There are some other  
restrictions as well, but it may be worth a look.

It would certainly be nice if extending collation in SQLite extended a  
little more into the deep code (in my own case I'd to change how NULLS  
are handled as well, but thats a different case).  But its also  
important to realize the value of SQLite, and some of that is exactly  
how minimal the core of it is.

--
Ian
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to