3.0.8, and I'm using sqlite3_bind_text16 to give the string.
On Thu, 27 Jan 2005 14:31:04 -0800, Will Leshner <[EMAIL PROTECTED]> wrote: > 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? > -- Cory Nelson http://www.int64.org
