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

What is the encoding of your PHP file: Polish or UTF-8?

Viliam Búr
– Viliam Búr

2012-08-22 07:19:32 +00:00
Commented Aug 22, 2012 at 7:19 — Viliam Búr
– Viliam Búr, Commented Aug 22, 2012 at 7:19
the encoding of my php is utf-8

khartvin
– khartvin

2012-08-22 07:28:45 +00:00
Commented Aug 22, 2012 at 7:28 — khartvin
– khartvin, Commented Aug 22, 2012 at 7:28

Mihai Iorga · Accepted Answer · 2012-08-22 08:27:28Z

5

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);

edited Aug 22, 2012 at 8:27

answered Aug 22, 2012 at 7:04

Mihai Iorga

39.8k17 gold badges109 silver badges109 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

khartvin Over a year ago

yeah, i've tried that too, i get

PHP Warning:  PDO::__construct(): SQLSTATE[IM001]: Driver does not support this function: driver does not support setting attributes in ...

khartvin Over a year ago

thank you. however still - General error: 195 General SQL Server error: Check messages from the SQL Server [195] (severity 15) [SET NAMES 'utf8']

khartvin Over a year ago

unfortunately it doesn't change anything either. General Error 207 appeared again.

Mihai Iorga Over a year ago

I'm sorry, I must be blind, I saw MySQL first time. Try that command, it's UTF-8 for MsSQL

Mihai Iorga Over a year ago

And within setAttribute .. ?

|

Collectives™ on Stack Overflow

MsSQL encoding issue

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related