I am working with an SQL Server database on a windows server with
collation
SQL_Latin1_General_CP1_CI_AS
When I go to the rails console on the Linux server with the app I get
=> “Rodrguez, Csar”
To try to isolate the problem in my controller I tried render :text =>
but on the browser I am seeing
Rodr?guez, C?sar
I believe this is an encoding issue, but I don’t know how to
resolve.(and Google + Stackoverflow are failing me) Given that the
source data can’t be changed, what do I need to do on the rails side
to get the text to render properly?
On Chrome I have tried to manually change the encoding and no matter
which I select I can’t get the text to render correctly.
Also, why would it render correctly on the console?
Thanks,
Noel