Re: [GENERAL] Encoding Conversion

2011-02-03 Thread Tom Lane
Wilton Wonrath writes: > When I´m doing a conversion PostgreSQL returns SCAPES to me besides the > desire > caracter. Why ? Somewhere between 8.2 and 9.0 convert() was redefined to take and return bytea, not text, to reflect the fact that the data it deals in isn't necessarily encoded in the da

[GENERAL] Encoding Conversion

2011-02-03 Thread Wilton Wonrath
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: Du

Re: [GENERAL] Encoding Conversion

2006-05-10 Thread Rick Gigger
jef peeraer wrote: beer schreef: Hello All So I have an old database that is ASCII_SQL encoded. For a variety of reasons I need to convert the database to UNICODE. I did some googling on this but have yet to find anything that looked like a viable option, so i thought I'd post to the group

Re: [GENERAL] Encoding Conversion

2006-05-09 Thread jef peeraer
beer schreef: Hello All So I have an old database that is ASCII_SQL encoded. For a variety of reasons I need to convert the database to UNICODE. I did some googling on this but have yet to find anything that looked like a viable option, so i thought I'd post to the group and see what sort o

Re: [GENERAL] Encoding Conversion

2006-05-09 Thread Alan Hodgson
On May 9, 2006 01:03 pm, jef peeraer <[EMAIL PROTECTED]> wrote: > well i recently struggled with the same problem. After a lot of trial > and error and reading, it seems that an ascii encoded database can't use > its client encoding capabilities ( set client_encoding to utf8 ). > i think the easist

Re: [GENERAL] Encoding Conversion

2006-05-09 Thread jef peeraer
beer schreef: > Hello All > > So I have an old database that is ASCII_SQL encoded. For a variety of reasons I need to convert the database to UNICODE. I did some googling on this but have yet to find anything that looked like a viable option, so i thought I'd post to the group and see what so

[GENERAL] Encoding Conversion

2006-05-09 Thread beer
Hello All So I have an old database that is ASCII_SQL encoded. For a variety of reasons I need to convert the database to UNICODE. I did some googling on this but have yet to find anything that looked like a viable option, so i thought I'd post to the group and see what sort of advice might a