Re: [sqlite] Unicode select problem

Cory Nelson wrote: 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

Re: [sqlite] Unicode select problem

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 s

Re: [sqlite] Unicode select problem

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 '%ãã%

[sqlite] Unicode select problem

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 w