windows phone sqlite unrecognized token:”‘大”

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='大',but i can insert '大' to database..3.大 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='大',but it says unrecognized token:"'大"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