locked
Urgent! Unable to store unicode (chinese) to mysql database. RRS feed

  • Question

  • User944339287 posted

    Hello guys.. i have did a lot of research but no work work for me.

    My connection string

    DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=db_testing;UID=user_testing;PASSWORD=pwd12345;charset=utf8;OPTION=3; 

    My table structure

    CREATE TABLE `table1` (
    `ID` varchar(10) NOT NULL,
    `name1` varchar(100) NOT NULL,
    PRIMARY KEY (`ID`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    Column Collate: utf8_general_ci

    ----------------------------------------

    The data appear as ???? in database. Please advice. TQ

    Friday, November 16, 2012 5:43 AM

All replies

  • User944339287 posted

    pls help.. anyone know how to solve this problem?? 

    Saturday, November 17, 2012 8:50 PM