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