SQLServer + (OSX/linux) + accents

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