Imagine that I want to query my database for a certain type of word, the user could enter ΓΌ or ue and I will display the corresponding items...
It cannot be done in the application layer... Best regards, Sylvain On Tue, Dec 22, 2009 at 8:15 AM, Nicolas Williams <nicolas.willi...@sun.com>wrote: > On Tue, Dec 22, 2009 at 06:56:29AM +0000, Simon Slavin wrote: > > On 22 Dec 2009, at 4:55am, Sylvain Pointeau wrote: > > > How is [this?] supposed to work ICU in SQLite? > > > > I hope someone can answer your question. I don't know enough. > > I don't know about ICU but, really this is something that needs to be > handled where you have enough context to decide if a given equivalent > spelling rule actually applies. You can only really do that at the > application layer, where you might know such things as the user's locale > (language, codeset, ...). By the time SQL collations are involved it's > probably too late and you'll get equivalences that you might not have > intended. > > Can you "normalize" any such strings at the application layer prior to > passing them to SQLite3? > > Nico > -- > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
