trying my best but still display ??? in database while inserting unicode text

Question

User944339287 posted

hi all, i knew this problem is popular in this forum but i still yet to solve my problem after tried all the found solution.

my connection string as below:

<add key="database" value="DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=my_db;UID=test;PASSWORD=123456;charset=utf8;OPTION=3;" />

I have also done the following:

ALTER DATABASE `my_db` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
ALTER TABLE `my_table`  DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;

Last but not least, i also added the following in web.config

<globalization requestEncoding="utf-8" responseEncoding="utf-8" />

Anyone can help me??? hundred thanks~

Answer 1

User1644485212 posted

What is your datatype in your table. If it is VARCHAR or text it will display such characters.... Try using NVARCHAR()

Answer 2

User1219881809 posted

Visit here:

http://forums.asp.net/p/1541518/3756857.aspx

Regards.