Encoding problems

Ruby
1

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.

2

On Jan 20, 4:46 pm, Noé Alejandro [email protected] wrote:

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)

3

Luis L. wrote:

On Jan 20, 4:46�pm, No� Alejandro [email protected] wrote:

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)

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 =(