Page 1 of 1

Unicode in ODBC Access

Posted: Thu Jul 08, 2010 12:37 am
by mysamsung
I am trying to insert , update some data into MS Access database using ODBC ,
that data came from
$string=html_entity_decode($unicodedata, ENT_NOQUOTES,'UTF-8')."\n";

that look like this " ബാലക്യഷ്ണന്*à´¨à "
i have worked on this with Mysql , which has connection collation mysql_query( "SET NAMES utf8") and it stores correct unicode data into table and its fine!,
but this not working for ODBC(MS Access),
please help me on this, how to insert ,update unicode data into ms access.

Thank you,
MYSAMSUNG

Re: Unicode in ODBC Access

Posted: Thu Aug 12, 2010 11:30 pm
by mysamsung
mysamsung wrote:I am trying to insert , update some data into MS Access database using ODBC ,
that data came from
$string=html_entity_decode($unicodedata, ENT_NOQUOTES,'UTF-8')."\n";

that look like this " ബാലക്യഷ്ണന്*à´¨à "
i have worked on this with Mysql , which has connection collation mysql_query( "SET NAMES utf8") and it stores correct unicode data into table and its fine!,
but this not working for ODBC(MS Access),
please help me on this, how to insert ,update unicode data into ms access.

Thank you,
MYSAMSUNG
I think nobody is in this problem before.