MySql Connector for Dotnet and Utf-8 in C#
I'm using MySql for a small project as the database backend with the MySql Connector for .Net by MySql AG. (this was done by ByteFX formerly) and found out that however the tables were created to be UTF-8, INSERT and UPDATE were failing on special (Hungarian, Russian etc.) characters!
After some RTFM, I found the appropriate solution: add the
charset=utf8;
part to your connection string, and everything will be nice and lovely :)