Hello!
I am experiencing troubles with MySQL 5.0, Connector.NET 1.0.8 and utf8 columns.
I have table named "myuser", with 3 columns:
id int
firstname varchar(50) collation utf8_general_ci
lastname varchar(50) collation utf8_general_ci
Now, I want to edit user details on the form, but i am unable to display characters properly from this table - they get all messed up. For example:
Über comes to Ã?ber or something like this. What should I do?
Connection string is
Server=server;Database=database;User ID=user;Password=password;CharSet=utf8
If I do not specify utf8, all non-ascii characters are replaced with question marks. What to do?
|