Export to GitHub

csharp-sqlite - issue #93

chinese charset


Posted on Mar 5, 2011 by Massive Elephant

What steps will reproduce the problem? 1. SQLiteClient.SqliteCommand.CommandText="Insert Into T1(v1)values('中文')"; // values context is 'chinese'

What is the expected output? What do you see instead? expected output '中文' (chinese),but I see ??????

What version of the product are you using? On what operating system? version is csharp-sqlite_3_7_5. My OS is WIN7 x64

Please provide any additional information below.

in File Community.CsharpSqlite.SQLiteClient/SqliteCommand.cs Line 107 public string CommandText { get ... set { ASCIIEncoding ascii = new ASCIIEncoding(); sql = ascii.GetString( Encoding.UTF8.GetBytes( value ) ); prepared = false; // ascii->utf8 it is wrong to change ascii directly to utf8 ,which is unseay be discovered in English char,but is obvious in Chinese char
} }

Comment #1

Posted on Mar 5, 2011 by Massive Elephant

public string CommandText { get ... set { sql = value;
} } This is correct. sorry, my English is very very not good

Comment #2

Posted on Mar 6, 2011 by Swift Dog

This issue was closed by revision 3348f9c076.

Status: Fixed

Labels:
Type-Defect Priority-Medium