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

2004-07-18 Thread Dario V. Fassi
de 10) importat UTF-8 datas /usr/local/postgres/bin/psql db_unicode < db_without_blobs.dump 11) export datas with blobs in binary format. 12) import this dump info db_unicode . Best Regards, Patrice Trognon. Ð’ Ð’Ñ?к, 18.07.2004, в 01:34, Dario V. Fassi пишет: Tom Lane wrote

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

2004-07-17 Thread Dario V. Fassi
Tom Lane wrote: "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

[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