Windows Phone SQLite unrecognized token: "'Big"

What steps will reproduce the problem?1. i'm using the latest version of csharp-sqlite2. I want to select a row from DB, just like select * from test where name = 'day ', but I can insert 'day' to database .. 3. large is a Chinese character.What is the expected output? What do you see instead?It expected that will be shown a row there the name = 'day', but it says unrecognized token: "'Big"What version of the product are you using? On what operating system?I'm using csharp-sqlite_3_7_7_1_71.zip, win7 64bit to develop, and develop for Windows Phone 7.1 SDKPlease provide any additional information below.Thank you very much
 

Comment 1 by bright2k@gmail.com , Apr 8, 2012

It is because tokenize_c.cs casts a unicode Char to byte where the higher byte is lost and the some Chinese characters are processed as ASCII then caused the parse error. I made some small changes where at lease the select of Chinese characters works fine (enough for me), hope this helps to fix this issue and other potential similar problems.
 

Unicode-tokenize.diff 3.9 kb View Download

comment
2
by

sinfias...@163.com,
APR 9, 2012

 @ bright2k@gmail.comI must offer my heartfelt thanks to you. the problem was solved the brilliantly. thank you! 

comment 3 by project member market.n...@gmail.com , APR 9, 2012

 thank you, patch added into current release 

Status: accepted
owner: noah.hart@gmail.com
labels: milestone-3.7.11