Andy, >Hwever, what I want to do is seach for all of these varients too, i.e. so >that if I search for e that I get all of the e and accented e' etc, is >this >possble using something like the collation, or do I need to specify all of >them individually?
I'm about to release the beta of an SQLite extension providing Unicode locale-independant functions for collation, casing functions and a fuzzy comparison. Since it's locale-independant, it's far from perfect and won't fit every need, but should be usable in a number of situations. The collation has a major drawback: it relies of a Windoze function entirely (which should be portable and stable in the Win world). The fuzzy search and string casing functions rely on on-board Unicode tries. The whole thing is around 100k. Speed is just like functionality: somewhere between bare-bone pure ASCII native SQLite support and full blown ICU. Last problem: the registration of functions that override native SQLite functions is still problematic in some environments. This is what blocks me from decent testing. Let me know if your interessed. Again, this is not yet even beta... _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
