SQL DRIVER FOR PHP / MSSQL 2008 Standard Edition (64-bit) SP4 (10.0.6000.29)
we have a software developped in PHP that was running under
windows server 2008 R2 64bits - MSSQL 2008 32 bits
we migrate the software yesterday from 32 bits to 64 bits.
and all the troubles began ....
Important to specify that we did the same migration a few weeks ago in our test servers and it works perfectly.
In our production server, one of our big problem is charset .
the soft is using iso-8859-1 (french accent)
we have problem with words with accent like é (see attached file)
I compared test and production server, and I don't see any difference !
same Apache/2.2.17 (Win32) PHP/5.3.21
same sql driver for PHP: php_pdo_sqlsrv_53_ts.dll (3.0.3421)
same windows 2008 R2 Enterprise SP1
same MSSQL 2008 Standard Edition (64-bit) SP4 (10.0.6000.29)
same SQL Server Native CLient 11.0 2011.110.5058.00 15/05/2014
please see attached php info of both servers. do not see important difference.
for connexion I use this code
$iConnect = new PDO($connectString, NULL, NULL);$iConnect->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);$iConnect->setAttribute(PDO::SQLSRV_ATTR_ENCODING, PDO::SQLSRV_ENCODING_SYSTEM);
I connected my test apache/php to sql production, and no problem of accent.
so the problem seems to be in apache or in php , not in the sql database setup.....