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](http://www.microsoft.com/en-in/download/details.aspx?id=20098). Please help