Igor Tandetnik schrieb: > "Alexey Pechnikov" <[EMAIL PROTECTED]> wrote in > message news:[EMAIL PROTECTED] >> ? ????????? ?? Sunday 20 July 2008 21:20:19 Jay A. Kreibich >> ???????(?): >>> The good news is that you can re-implement the LIKE function fairly >>> easily. There have been a number of posts in the past dealing with >>> using external Unicode/I18N libraries to implement a more complete >>> 'LIKE' function. >> There is unicode extension in /ext/icu of SQLite source code. > > With ICU extension, LIKE operator may consider Ö and ö to be equal, but > is still unlikely to make ö and o equal. > You might try to store all your words in one of the decomposition normalization forms (NFD or KNFD would work, see http://unicode.org/reports/tr15/) than your LIKE match should find o and ö, but you might need to apply some other normalization to compose chars again on output.
Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax: +49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: [EMAIL PROTECTED] Sitz der Gesellschaft: Bremen Geschäftsführer: Karl Heinz Zachries, Ralf Holtgrefe Eingetragen im Handelsregister des Amtsgerichts Bremen unter HRB 13215 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
