Retrieve Chinese characters from MSSQL

Could anyone advise how i can retrieve Chinese characters (or other unicode characters) from MSSQL in tpl ?

I have added "qq{SET NAMES 'utf8';};" , but it doesn't work.

$dbh = DBI->connect("DBI Smiley Surprised

DBC:$database", $username, $password);
my $sql = qq{SET NAMES 'utf8';};
$dbh->do($sql);

I also tried "iw_sql_open", but make no different.

(PS: I m able to see the characters in database)

Thanks

Find more posts tagged with

Comments

nancool

Hi,

Which drivers you are using to connect to MSSQL database FreeTds/unixodbc ?

If it is freetds then probably u need to set client-characterset=UTF-8 in freetds.conf.

Thanks,
Nandan

djminmin

we use jdbc driver.

i have tried changing the collate in query but it doesn't work either

"SELECT name_jp = name_jp COLLATE DATABASE_DEFAULT FROM table"

Adam Stoller

MSSQL does not use UTF-8.
You need a DBA (or DB-programmer) to create a function in the database to convert from the native encoding (UTF-16 if I recall) to UTF-8 and then use that function in your queries.

I think I posted something about this around last October (+/- month) - but you can also find some of the information by googling for MSSQL and UTF-8

SeriesColorScript.rptdesign