Re: [sqlite] Unicode select problem

[John LeSueur]

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 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?
   


 

have you tried
where value like '??'
without the wildcards?
I've seen this happen with english before, where sqlite doesn't find it 
correctly using = and does find it using like.

John