Inserting Danish characters to sql server from PHP
php, sql-server, sql-server-2008-r2
Solution
I used a work around, just html encoded the danish string before insering into table, and when displaying just decoded back
Problem
When inserting danish characters to sql server to a field with an nvarchar datatype the danish characters get malformed. Example: brændstof is converted to brændstof. When it is directly from sql server query window it is working correctly. I tried giving different collations to that field(Latin1_Genaral,Danish_Greenlandic_100_CI_AI,Danish_Norwegian_CI_AI etc.) Is there a way to achieve this. I am using Microsoft Drivers 3.0 for PHP for SQL Server. Please help