C#: Unicode from a string with MySQL

Question

I'm trying to insert a string into a MySQL database. I can insert it by running the query on the server, but when I try to use my C# source file to insert "Iñtërnâtiônàlizætiøn", I get "Iñtërnâtiônàlizætiøn". I've tried adding it as a parameter and adding ;charset=utf8 to my connection string, but no look. The table in the database has utf8 as it's character set. Am I missing something.

This is my code (using a StringBuilder):

sqlBuffer.Append(string.Format(@"INSERT `resources` (id, somefield) VALUES (20004,'Iñtërnâtiônàlizætiøn');");

Answer 1

You need to specify that it's unicode/utf8 with N'' or _utf8'':

sqlBuffer.Append(string.Format(@"INSERT `resources` (id, somefield) VALUES (20004, N'Iñtërnâtiônàlizætiøn');");