Home > mailing lists

Encoding Conversion - Mailing list pgsql-general

From	Wilton Wonrath
Subject	Encoding Conversion
Date	February 3, 2011 10:09:55
Msg-id	154973.57502.qm@web34301.mail.mud.yahoo.com Whole thread Raw
Responses	Re: Encoding Conversion (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-general

Hi,

When I´m doing a conversion PostgreSQL returns SCAPES to me besides the desire caracter. Why ?

Using Postgresql 8.2:

SELECT CONVERT('RejeiÃ§Ã£o: Duplicidade de NF-e, com diferenÃ§a na Chave de Acesso [35110100608804000178550010001009471840996034]','UTF8','LATIN1')

Result: "Rejeição: Duplicidade de NF-e, com diferença na Chave de Acesso [35110100608804000178550010001009471840996034]"

Using Postgresql 9.0:

SELECT CONVERT('RejeiÃ§Ã£o: Duplicidade de NF-e, com diferenÃ§a na Chave de Acesso [35110100608804000178550010001009471840996034]','UTF8','LATIN1')

Result: "Rejei\347\343o: Duplicidade de NF-e, com diferen\347a na Chave de Acesso [35110100608804000178550010001009471840996034]"

Both databases are "encoding latin1".

Both servers are "Linux".

Regards,

Wilton Ruffato Wonrath

From: Adarsh Sharma
Date: 03 February 2011, 07:52:01
Subject: Select Command in Procedures

From: Thom Brown
Date: 03 February 2011, 10:32:00
Subject: Re: Issues with generate_series using integer boundaries