about sql execute error again

[GoogleCodeExporter]

Hi

yesterday I propose a question by Issue 147

What steps will reproduce the problem?

I execute sql like below:
----------------------------------------------------------------------------
create table tab_orders(id INTEGER,orderDate TEXT,agencyName TEXT,prodName 
TEXT,prodNum INTEGER,prodUnit TEXT,status TEXT,remark TEXT,confirm INTEGER);

insert into tab_orders 
values(1,'2012-02-01','001-南京饭店','青岛纯生啤',2000,'12瓶一箱','�
��到货','暂未到货',0);

The insert sql execute error.

What version of the product are you using? On what operating system?

version: csharp-sqlite_3_7_7_1_64.zip.
operating system: windows phone 7.(here,I wrote wrong yesterday)

--------------------------------------------------------------------------------
but the below sql execute right.

create table tab_orders(id INTEGER,orderDate TEXT,agencyName TEXT,prodName 
TEXT);

insert into tab_orders 
values(1,'2012-02-01','001-南京饭店','青岛纯生啤');
--------------------------------------------------------------------------------
most of sql including GB2312 encoding execute well. so I think It's not because 
of encoding.

Thank you.

Original issue reported on code.google.com by wszjdn...@gmail.com on 27 Mar 2012 at 1:43