Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE encoding

2004-07-17 Thread Tom Lane
"Dario V. Fassi" <[EMAIL PROTECTED]> writes: > A simple question, we need to migrate many (>20) postgres databases from > SQL_ASCII encoding to UNICODE encoding, over a 7.3.6 server. SQL_ASCII is not an encoding (it's more like the absence of knowledge about an encoding). What is the data actual

[ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE encoding

2004-07-17 Thread Dario V. Fassi
A simple question, we need to migrate many (>20) postgres databases from SQL_ASCII encoding to UNICODE encoding, over a 7.3.6 server. With  Dump/Restore , we get an error (Invalid Unicode) in any field that has a 8 bits character coming from the SQL_ASCII , even setting the client_encoding t