I have a web application that needs to support many languages including non latin character sets like, Russian, Chinese & Arabic. We are using .php and the Yii framework. Problem is when we write to SQL server even with the nvarchar type set the db columns, they contain ???? instead of the proper characters. Now, if I use visual studio management studio and cut and paste the Chinese chars in directly they look ok.
Firstly, what settings do I need to setup the MS SQL server to support UTF-8 and non latin char sets, could I have the TSQL required?
Secondly, why does this go wrong when we write to the db in .php?
Thanks for your help in advance.