Encoding UTF-8 / Umlauts
Christoph Kautz <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <385BE4BFF3AA1340B4967C107A0157E82354F16FC5@exchsrv.intern.solution-x.com> |
Hello list! ;-)
I'm trying to write&read data with php to/from a microsoft sqlserver 2008 but I am running into character conversion problems with Umlauts and Cyrillic letters.
I have tried different freetds configs but there is always one case which does not work. on one of the my servers I have installed freetds 0.82. if I put the server entry in freetds.conf like this:
[mssql.server]
host = mssql.server
port = 1433
tds version = 8.0
client charset = UTF-8
I can write/read umlauts(äöü) to/from the db and they are displayed correctly. But Cyrillic or greek letters are not stored/displayed correctly.
If I don't specify a client charset:
[mssql.server]
host = mssql.server
port = 1433
tds version = 8.0
umlauts, cyrillic, greek letters are displayd as question marks.
I have tried to reproduce the same config on an old debian sarge server with freetds 0.61 installed and on this server everything is working fine - I can read/store äöü + Cyrillic and greek letters from/to the same database as used above.
Could someone give me a hint how I could make the behavior of the server with current freetds libraries match the server with the old ones? :)
Help would be very much appreciated!
Regards,
chris