[freetds] Charset issues...

Reid, Roger L. roger.reid at dpw.com
Tue Jul 31 12:08:16 EDT 2007


Amazing!  

I am sweating bullets over a conversion issue and almost deleted this incoming FreeTDS mail without reading it - and 
JKL gave me the EXACT answer I needed - and I'm not the one who asked.   It hadn't occurred to me yet that it
might be an issue in the char mapping within FreeTDS. It was, and it took me about 30 seconds to solve it.

I don't know if this helps Michael Higgins, who asked - but it just saved me a lot of barking up the wrong tree.

Guess I should go play the lottery now!

roger reid

-----Original Message-----
From: James K. Lowden [mailto:jklowden at freetds.org] 

....

which should "use the native environment".  In your case, it's the
default: the 'C' locale, the encoding (charset) for which is ASCII a/k/a
ANSI_X3.4-1968.  

Voila!  When FreeTDS attempts to convert your smart quote to ASCII, it
fails, and you get '?' instead.  

HTH.  

--jkl



More information about the FreeTDS mailing list