Hi
I am trying to find out if it is possible to use unicode with mssql using the ODBC connection functions (ODBC and not MSSQL).
Currently I am running PHP 5.2.5 with mb_string extension (UTF-8 charset) (IIS7 Vista) and I get the following behaviour with Russian Text:
I insert data as follows: INSERT INTO table_name VALUES(N'russian_text')
And all browsers manage to insert and retrieve the data without any errors.
But the problem is that in the actual database the data appears as garbled text (viewed through management studio).
It seems that PHP or ODBC is transparently converting the data between PHP and SQL server. I have played around with the autotranslate property in the connection string without success.
So basically is it possible to use unicode based on the components choosen (if so how can I fix it) or should I use some other connection class?
Many Thanks
