From: Xavier Poinsard <xpoinsard@openpricer.com>
To: pgsql-jdbc@postgresql.org
Subject: Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE
Date: Mon, 19 Jul 2004 14:46:18 +0200
Message-ID: <cdgfqq$vmn$1@sea.gmane.org> (raw)
In-Reply-To: <40FAD3C8.3080503@sistemat.com.ar>
References: <40F98613.1060405@sistemat.com.ar>
<16994.1090099096@sss.pgh.pa.us>
<40F9B599.6080205@sistemat.com.ar>
<28179.1090132144@sss.pgh.pa.us>
<40FAD3C8.3080503@sistemat.com.ar>
Dario V. Fassi a écrit :
>
> Tom Lane wrote:
>
>>"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).
>>
did you try the recode utility ?
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: xpoinsard@openpricer.com, pgsql-jdbc@postgresql.org
Subject: Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE
In-Reply-To: <cdgfqq$vmn$1@sea.gmane.org>
* 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