0

I'm support my project multi language in yii framework. In SQL Server the translated column datatype is nvarchar(max). If i select the translated message it shows empty in php pdo connecting via pdo odbc.

The query i'm using

SELECT translation COLLATE SQL_Latin1_General_CP1_CI_AS as messagedata FROM translated_message

Inside foreach i'm using to display the unicode characters iconv('UCS-2LE', 'UTF-8', $message);

But it will display junk characters. How can i display it the unicode characters.

Thanks..

Aruljothi
  • 497
  • 1
  • 6
  • 14

0 Answers0