Edward_jie

for you, my Hall of Frame

  博客园 :: 首页 :: 博问 :: 闪存 :: 新随笔 :: 联系 :: 订阅 订阅 :: 管理 ::
What steps will reproduce the problem?
1.I'm using the latest version of csharp-sqlite
2.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 sdk

Please 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.com

I 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

posted on 2012-10-10 22:19  Edward_诺  阅读(1737)  评论(5编辑  收藏  举报