On 06/06/2012 04:30 AM, Manoj Agarwal wrote:
Hi,
I have a database in SQL_ASCII Encoding format from Postgresql-7.4.19. I
have migrated to Postgresql-8.4.9 and to UTF-8 and want to restore this
database in UTF-8 encoding. I am facing problem in restoring it as
UTF-8. I have 29 tables in the database, out of which it is unable to
restore 3 tables. It gives the following error:
I have checked these three tables and I found that these tables contain
special characters as values for some attributes for some records. I
tried to use the procedure mentioned in the following link, which didn’t
worked for me:
http://archives.postgresql.org/pgsql-admin/2004-07/msg00206.php
I also have blobs in one table in this database, but I don’t think/see
any issues with them. Is there a way to restore the database from
SQL_ASCII to UTF-8? Is there a way to restore the database as SQL_ASCII
and then convert the Encoding to UTF-8? What is the consistency level?
Or are there chances of getting garbage?
SQL_ASCII is not an encoding, it is basically a way of saying encoding
ignored. Given that, outside knowledge of the encoding used for data
inserted into the database is needed to make the conversion to UTF8. In
other words do you have any idea of what encoding was used by the
clients that supplied data to the database?
Kind Regards,
Manoj Agarwal
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
