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