Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 18, 2012 12:50 AM by kengkit
Member
120 Points
251 Posts
Nov 16, 2012 09:43 AM|LINK
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
Nov 18, 2012 12:50 AM|LINK
pls help.. anyone know how to solve this problem??
kengkit
Member
120 Points
251 Posts
Urgent! Unable to store unicode (chinese) to mysql database.
Nov 16, 2012 09:43 AM|LINK
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
kengkit
Member
120 Points
251 Posts
Re: Urgent! Unable to store unicode (chinese) to mysql database.
Nov 18, 2012 12:50 AM|LINK
pls help.. anyone know how to solve this problem??