Monday, 15 September 2014

php - MSSQL character coding -


I am using ZF1 and MSSQL, I am using free TDS.

Today I'm making a backup ("For the test purposes the script" generated in studio management ", and I had to face a strange problem. In DB I see that ś, ć, ż etc. Like every letter is saved properly, but when I run a specific question in the ZF, I get some strange characters when I look in the DB.
This is really a troublesome problem, and I have had it last 4-5 hours Fixed Tried to do and still nothing.

I tried that:

  • ini_set ('mssql.charset', 'UTF-8');
  • set column in nvarchar, nchar
  • mb_convert_encoding ($ data, 'UTF-8')

JSON Decoded, but the characters are still wrongly decoded. (Without this method I get only "invalid UTF-8 ..." error)

Please enter the Freetds configuration file located in my server

  (/ usr / local / freetds / etc / freetds .config)  

Edit the file and set the client charset for the utft


No comments:

Post a Comment