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