Connecting with SQL Server: mssql_ or sqlsrv_ ?
Posted: Thu Sep 17, 2009 10:17 am
Hi,
I am just getting started writing an application in PHP that interacts with a SQL Server database. The administrator of the system installed PHP with mssql_ functions enabled. They work perfectly, but we cannot get UTF-8 characters to display properly.
He has abandoned this setup and installed SQL Server Driver for PHP 1.1. Now I have to study sqlsrv_ functions and rewrite what I have. That is fine, but I am not confident I am heading down the right path. I would much prefer to stick with the php than go to MS.
Is the unicode problem related to the mssql_ functions, or is there another problem the administrator is missing? Is Microsoft's driver worth working with?
Thanks!
I am just getting started writing an application in PHP that interacts with a SQL Server database. The administrator of the system installed PHP with mssql_ functions enabled. They work perfectly, but we cannot get UTF-8 characters to display properly.
He has abandoned this setup and installed SQL Server Driver for PHP 1.1. Now I have to study sqlsrv_ functions and rewrite what I have. That is fine, but I am not confident I am heading down the right path. I would much prefer to stick with the php than go to MS.
Is the unicode problem related to the mssql_ functions, or is there another problem the administrator is missing? Is Microsoft's driver worth working with?
Thanks!