MsSQL encoding issue

Question

i have a database in MsSQL, with which i connect from my PHP code through PDO objects. the database has column "Kadź".

Now - if i execute a

SELECT Kadź FROM <tablename>

query from my SQL Server Management Studio - everything works fine, i get the results. However, when i try to execute a

$sql = "SELECT Kadź FROM <tablename>";

i recieve a

SQLSTATE[HY000]: General error: 207 General SQL Server error: Check messages from the SQL Server [207] (severity 16) [(null)]

error. Querying any other column doesn't produce any problems, but this one does. I suspect it's because of that "ź" character in the name of this column, that is unproperly encoded on the route between my PHP code and the database.

The collation used by my server is "Polish_Cl_Al". i've tried fixing it by adding attribute

$this->setAttribute(PDO::MYSQL_ATTR_INIT_COMMAND, "SET NAME'utf8'");

but the PDO answered me, that the driver doesn't support it...

thanks in advance for any help

Answer 1

You can try:

$pdo = new PDO('dblib:host=localhost;dbname=databasename;charset=UTF-8', 'username', 'password');

or (for windows)

$smth->setAttribute(PDO::SQLSRV_ATTR_ENCODING, PDO::SQLSRV_ENCODING_UTF8);