Are there some limitations in SQLite's Unicode support? I'm trying to select some rows that contain Japanese in them. It seems that when I do "where value='ãã'" I get no results. But with "where value like '%ãã%'", it returns results. This happens when value is an exact match! Doesn't happen when selecting English.
-- Cory Nelson http://www.int64.org
