Hi all,

We're trying to get a big dictionary website running on SQLite (was MySQL),
but we ran into some trouble that we can't really seem to fix.

While we're using UTF-8 coding, a query like

 SELECT * FROM language WHERE word like '%o%'

doesn't find words with Ö or ö, while it did in MySQL. Also the case with
for example a for àáâãä and å.

Is it just a simple configuration thing maybe? Or is sqlite just not ready
for these kind of searches?

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

Reply via email to