César Amador wrote:
I wrote a RoR app on OSX and SQL Server. The DB uses SQL_Latin1, so I use Iconv to convert to UNICODE every dynamic text I show on the pages (Iconv.conv('utf-8', 'iso-8859-1', string)). That's been working fine until I deployed the app on a debian box. Since then, the accents are shown as question marks, and I don't know why.
It sounds like the same issue I had. Basically FreeTDS defaults to converting any 8 bit character (or something like that) to '?' unless you tell it not to.
You should be able to fix your issue by adding:
client charset = ISO8859-1
to your connection settings in your freetds.conf