Fix Unicode value error at INSERT.

jchristn / DatabaseWrapper

Simple database wrapper for Microsoft SQL Server, MySQL, PostgreSQL, and Sqlite written in C# supporting dynamic query building and nesting using expressions.

MIT License

97 stars 26 forks source link

Fix Unicode value error at INSERT. #4

Closed daoye closed 3 years ago

daoye commented 3 years ago

There is no need the prefix "N", which will cause SQLite to prompt a syntax error.

You can use value "游戏" to test it at insert.

jchristn commented 3 years ago

Thank you @daoye - merging now and will publish an update!

jchristn commented 3 years ago

NuGet (DatabaseWrapper): https://www.nuget.org/packages/DatabaseWrapper/3.2.2.17 NuGet (DatabaseWrapper.Sqlite): https://www.nuget.org/packages/DatabaseWrapper.Sqlite/3.2.2.17 Commit: https://github.com/jchristn/DatabaseWrapper/commit/7ffa22b84eb9616e0a227a1980372353030a2a99