| From: | Wilton Wonrath <wrwonrath(at)yahoo(dot)com(dot)br> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Encoding Conversion |
| Date: | 2011-02-03 11:03:00 |
| Message-ID: | 154973.57502.qm@web34301.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2011-02-03 11:23:19 | Re: Select Command in Procedures |
| Previous Message | Adarsh Sharma | 2011-02-03 08:56:10 | Select Command in Procedures |