-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Friday, June 08, 2012 2:19 AM
To: Manoj Agarwal
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Problem while restoring a database from SQL_ASCII to
UTF-8
On 06/06/2012 08:30 PM, Manoj Agarwal wrote:
>
On 06/06/2012 08:30 PM, Manoj Agarwal wrote:
Hi,
The encoding that is used by the clients that supplied data to the database
is ISO-8859-1.
I meant to ask in my previous post:
1) What are the special characters causing the problem?
2) What is the data type for the fields holding these charac
On 06/06/2012 08:30 PM, Manoj Agarwal wrote:
Hi,
The encoding that is used by the clients that supplied data to the database
is ISO-8859-1.
You said previously that you had 29 tables in the 7.4 database and three
of those had errors when upgrading to the 8.4 database. At what state is
the 8.
Subject: Re: [GENERAL] Problem while restoring a database from SQL_ASCII to
UTF-8
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
> t
On 6 June 2012 14:12, Adrian Klaver wrote:
> 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
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 data
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
