Mark8236 / csharp-sqlite

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

problem in inserting the unicode string in sqlite database #137

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1.I m using sqlite latest version.
2.i want to insert 
आइईउऊऋऎएऐऒओऑऔकखगघचछजज़झटठडढ��
�थदधनपफबभमयय़रऱलवशषसह this string into the 
database.
3.when i execute the query it will fired the exception "unrecognized token"

What is the expected output? What do you see instead?
i want to insert this unicode string into the database.

What version of the product are you using? On what operating system?
i m using csharp-sqlite_3_7_7_1_71

Please provide any additional information below.
were

Original issue reported on code.google.com by kaduchan...@gmail.com on 25 Jan 2012 at 6:13

Attachments:

GoogleCodeExporter commented 8 years ago
C#SQLite is a UTF-8 application;  You are trying to insert a Unicode string

@"INSERT INTO person (firstname) VALUES 
('अआइईउऊऋऎएऐऒओऑऔकखगघचछजज़झटठड
ढतथदधनपफबभमयय़रऱलवशषसह')";
See the full discussion in issue 52;

http://code.google.com/p/csharp-sqlite/issues/detail?id=52&can=1&q=UTF

Original comment by noah.hart@gmail.com on 28 Feb 2012 at 1:48