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..