On Thu, 27 Jan 2005 13:59:45 -0800, Cory Nelson <[EMAIL PROTECTED]> wrote: > 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.
It seems to work for me. What version of SQLite are you using? And what are you using to enter queries?
