Encoding problems

[Noé Alejandro]

Hi all.

I have a database (sqlite) with Ansi - Latín I codepage. With a Select
statement in Ruby, the data returned are in UTF-8. E. g.:

Database: ocupación
Ruby : ocupaci\xC3\xB3n

How can I display the correct data (i. e., ocupación)?

Thanks a lot.

 

[Luis Lavena]

Hi all.

I have a database (sqlite) with Ansi - Latín I codepage. With a Select
statement in Ruby, the data returned are in UTF-8. E. g.:

Database: ocupación
Ruby    : ocupaci\xC3\xB3n

How can I display the correct data (i. e., ocupación)?

All that depends on the console encoding you're trying to output that
information to.

If is terminal on Linux/OSX, most likely is going to work as console
is UTF8

On Windows, you need the console be set the codepage to 1252, which is
not default (use chcp)

 

[Noé Alejandro]

Ruby � �: ocupaci\xC3\xB3n

All that depends on the console encoding you're trying to output that
information to.

If is terminal on Linux/OSX, most likely is going to work as console
is UTF8

On Windows, you need the console be set the codepage to 1252, which is
not default (use chcp)

Hi.

Im using JetBrains RubyMine IDE (windows). I put in the first line
# encoding: WINDOWS-1252

Is that enough? I run it but the problem is the same =(