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
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
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