FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

Tera wrote:
> Does FreeTDS support translation
> between charsets? 

Yes, for Microsoft servers using version 7.0 or 8.0 of the TDS protocol.  

> In our particular situation client is on Mac OS with
> french localization (app encoding is MacRoman) and server
> localization is Latin 1 (Windows 1252). 

If you iconv library supports those two encodings, it should work. In your
freetds.conf, try:

        client charset = MACROMAN

(assuming you're using Apple's iconv library).  FreeTDS will detect the
server's charset and convert between them.  You can confirm what it's
doing by setting TDSDUMP; the encodings are recorded at the beginning of
the log file. 

HTH.

--jkl