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

  • 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~

    Monday, August 1, 2011 12:18 PM


All replies