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.
Please or to participate in this conversation.