Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

mpao's avatar
Level 11

Unicode support on Debian with MS Sql Server

Hi guys, I am trying to deploy a website with Dhivehi Language with the following configurations.

Web Server: Apache, with Php 5.6, with freetds and dblib driver DB Server: Microsoft SQL Server 2014

I have migrated the data to the db with Unicode chars and website displays well. However when I update any post the whole Dhivehi text is displayed as ????????.

If I do the same update on SQL Management server with the following syntax the result is also the same

update posts set summary = 'ދގދފގދފގ' where id = 155

However If i put the N' in front of the text and update in management server row is updated as expected.

update posts set summary = N'ދގދފގދފގ' where id = 155

So far what I have learned is that laravel does not insert this N' in front of strings and how should I pass data from Linux web server to windows db server with this Unicode encoding. My connection string does have utf-8 and freetds config file also have utf-8 set.

Any ideas are welcomed thank you.

0 likes
0 replies

Please or to participate in this conversation.