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