C# string with special characters to MySQL varchar column

Question

I'm trying to add the following string from a C# application to a varchar column in a MySQL database.

"TVCM ｜ AU「FULL CONTROL／XMAS」篇　60秒"

It ends up like this

"TVCM | au?FULL CONTROL/Xmas???60?"

I've set default-character-set=utf8 in my.ini and set the DEFAULT CHARSET to utf8 for the database, the tables and the columns.

The code for inserting the string looks like this
(where title has the value TVCM ｜ AU「FULL CONTROL／XMAS」篇　60秒

string sqlQuery = "insert into myTable (Title) values (?Title)";
MySqlCommand command = m_connection.CreateCommand();
m_connection.Open();
command.CommandText = sqlQuery;
command.CommandType = CommandType.Text;
command.Parameters.Add(new MySqlParameter("?Title", title));
command.ExecuteNonQuery();
m_connection.Close();

Also, I'm using MySQL Connector.NET 6.6.4.

Any idea what my problem may be?

Chamila Chulatunga · Accepted Answer · 2012-12-06 10:57:27Z

4

I believe you can also specify the charset in the connection string - check if your connection string explicitly specifies "charset=utf8"

answered Dec 6, 2012 at 10:57

Chamila Chulatunga

4,95418 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Julio Borges · Accepted Answer · 2012-12-06 11:05:20Z

0

The problem must be in the charset of your development environment, the default file encoding of Visual Studio depends on the Windows setting. Following is the location That You can change it.

Control Panel | Regional and Language Options | Advanced | Inglês to change the language from the drop down list.

answered Dec 6, 2012 at 11:05

Julio Borges

67214 silver badges29 bronze badges

Collectives™ on Stack Overflow

C# string with special characters to MySQL varchar column

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related