search

yiskang / csharp-sqlite

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

encoding problem with SQLiteClient #73

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
in latest versioncsharp-sqlite_3_6_23.zip) downloaded from here, if I do CRUD 
with non-ascii characters, the actual data will be wrong, because SQLiteClient 
simply convert all characters to ascii before it executes.

for example, in SqliteCommand.CommandText

Original issue reported on code.google.com by unruled...@gmail.com on 27 Jul 2010 at 12:14

GoogleCodeExporter commented 8 years ago 
Can you post a sample of the CRUD code that creates the problem.

Original comment by noah.hart@gmail.com on 27 Jul 2010 at 10:27

GoogleCodeExporter commented 8 years ago 
See Issue 52, with solution 
Fixed in 20-Feb Check-in
changeset 52:c1b41c1ffdff

Original comment by noah.hart@gmail.com on 27 Jul 2010 at 11:16

GoogleCodeExporter commented 8 years ago 
I have same problem.

cmd.CommandText = "SELECT field FROM table WHERE field LIKE '%čćžđš%'"

This will return nothing.

I can't find the solution from that Issue 52.

Original comment by thehijac...@gmail.com on 1 Sep 2010 at 7:02

GoogleCodeExporter commented 8 years ago 
See Fix in issue 78

Original comment by noah.hart@gmail.com on 7 Sep 2010 at 4:39