Skip to Content.
Sympa Menu

freetds - Re: [freetds] Encoding UTF-8 / Umlauts

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Christoph Kautz <kautzy AT solution-x.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Encoding UTF-8 / Umlauts
  • Date: Thu, 19 Nov 2009 14:17:03 +0100

Hi again,

now I am totally confused.

If I completely remove the server section from freetds.conf umlauts, cyrillic
and greek works fine.

So to sum it up... what's not working is:
---
freetds.conf:

[mssql.server]
host = mssql.server
port = 1433
tds version = 8.0
client charset = UTF-8
---
and freetds.conf:

[mssql.server]
host = mssql.server
port = 1433
tds version = 8.0
---
if I remove the [mssql.server] part compeletely, I have ÖÜÄ and cyrillic
working with PHP.

But since I also want to access the mssql server from the commandline and
with ruby-odbc I need the server section in freetds.conf I guess...?

Best regards,
chris



-----Ursprüngliche Nachricht-----
Von: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] Im Auftrag von Christoph Kautz
Gesendet: Donnerstag, 19. November 2009 10:43
An: freetds AT lists.ibiblio.org
Betreff: [freetds] Encoding UTF-8 / Umlauts

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
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page