sentcacpamao
New Member
I have a problem with regional string characters inserted to MS SQL Server database. There is a PHP application that connects with mssql server and inserts some data. But instead of inserting characters such as: ?, ?, ?, ?, ? (and so on - btw. these are polish regional characters), when inserted into mssql table they appear as a, A, c, L, z. Here is some background:
- I use freetds drivers for mssql connectivity
- column type is nvarchar(MAX)
- I looked at data sent "trough wire" (with WireShark) and the UTF-8 encoded data looks ok, for example ? is sent as U+0104.
- When inserting same string into local database instance (Microsoft SQL Server Express Edition) it works fine, but on remote host (in customer location - it is Microsoft SQL Server Standard Edition 64-bit) this "de-regionalization" occurs.