youshido-php/GraphQLBundle

Malformed UTF-8 characters - connection to Microsoft SQL Server

PGBastien opened this issue · 2 comments

PGBastien commented

When i use a connection to mssql server, all is OK when i get data without special chars but i have an error when i get datas with special chars (ex : spécial caractères)/

Error message :
Malformed UTF-8 characters, possibly incorrectly encoded
JsonResponse->__construct(array('data' => array('articles' => array(array('CODE' => '334731', 'DESIGNATION' => 'sp**�**cial caract**�**res')))), 200, array('Access-Control-Allow-Origin' => '*', 'Access-Control-Allow-Headers' => 'Content-Type'))

I tried to modify (config.yml) option charset (utf-8,iso-8859-1)in my mssql connection but it don't work !

PGBastien commented

Is that someone would have an idea ?

PGBastien commented

For your information, it works on windows environment with microsoft PHP drivers for MSSQL 👍
https://www.microsoft.com/en-us/download/details.aspx?id=20098

I will test this drivers https://github.com/Microsoft/msphpsql on linux environment