Inserting Chinese characters are messy code

[xlp100]

There will be problems with the following code:

string utf8String = @"INSERT INTO pstate(id, name, remark) VALUES(233, '中文', NULL);";
cmd.Execute(utf8String);

but it is ok:

string utf8String = @"INSERT INTO pstate(id, name, remark) VALUES(233, ?, NULL);";
cmd.Execute(utf8String,'中文');

What is the difference between the two?

[Weldryn]

The first statement does not use the ORM but the second one does. Rule of thumb: Use the second form if you have parameters

[praeclarum]

Yes I'm sorry that this is a limitation of the current API and parameters should be used.

That said, I am going to look into whether this can be fixed.