From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dario V. Fassi <software@sistemat.com.ar>
Cc: Oliver Jowett <oliver@opencloud.com>
Cc: pgsql-sql@postgresql.org, "pgsql-jdbc@postgresql.org" <pgsql-jdbc@postgresql.org>
Subject: Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE
Date: Sun, 18 Jul 2004 02:29:04 -0400
Message-ID: <28179.1090132144@sss.pgh.pa.us> (raw)
In-Reply-To: <40F9B599.6080205@sistemat.com.ar>
References: <40F98613.1060405@sistemat.com.ar>
<16994.1090099096@sss.pgh.pa.us>
<40F9B599.6080205@sistemat.com.ar>
"Dario V. Fassi" <software@sistemat.com.ar> writes:
>> SQL_ASCII is not an encoding (it's more like the absence of knowledge
>> about an encoding). What is the data actually stored as?
> Yes you are right , the original data come from a DB2 with CodePage
> IBM-850 and was inserted without complains in a Postgres 7.3.6 with
> SQL_ASCII.
Ugh. You'll have to work out how to convert that codepage to one of the
encodings that PG supports. Or else add it as a supported encoding
(I'm not sure how hard that is, but it's not out of the question).
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, software@sistemat.com.ar, oliver@opencloud.com, pgsql-jdbc@postgresql.org
Subject: Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE
In-Reply-To: <28179.1090132144@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox