search

longde123 / csharp-sqlite

Automatically exported from code.google.com/p/csharp-sqlite
Other
0 stars 0 forks source link

like query result problem #163

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
I compiled csharp-sqlite and there is a problem about like query,and I have no 
idea .My project is below,it happened the query of "select distinct stationName 
from lineStation where stationName like @para",but only one result return.In my 
opinion,it can return at least 300 result,can you help me?
1.run it with 
\Community.CsharpSqlite.SQLiteClient.WP\Community.CsharpSqlite.SQLiteClient.WP.s
ln ,compile and running,but only one result return.
2.林 is a Chinese character.

What is the expected output? What do you see instead?
output is 林坞口,but instead,it must be above 300 results output

What version of the product are you using? On what operating system?
I'm using csharp-sqlite_3_7_7_1_71,win7 32bit to develop, and develop for 
windows phone 7.1 sdk

Please provide any additional information below.
many thanks

Original issue reported on code.google.com by knightlu...@gmail.com on 24 Jun 2012 at 3:37

Attachments:

GoogleCodeExporter commented 9 years ago

Original comment by noah.hart@gmail.com on 29 Jun 2012 at 10:17

GoogleCodeExporter commented 9 years ago 
I'd like to offer another linked issue which is also using like operator to 
query records contain Chinese chars. I will offer a reproduce source code to 
help you repro the bug conveniently.

Original comment by sunshak...@gmail.com on 24 Oct 2012 at 12:28

GoogleCodeExporter commented 9 years ago

Original comment by noah.hart@gmail.com on 29 Oct 2012 at 7:38

GoogleCodeExporter commented 9 years ago 
Waiting for the fix.

Original comment by sunshak...@gmail.com on 30 Oct 2012 at 11:02

GoogleCodeExporter commented 9 years ago 
How is it going?
I'm waiting for the fix. :)

Original comment by sunshak...@gmail.com on 6 Dec 2012 at 12:02