From: Michael Stephenson <mstephenson@openworld.org>
To: Dario V. Fassi <software@sistemat.com.ar>
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: Mon, 19 Jul 2004 10:25:49 +0000
Message-ID: <40FBA1AD.2050904@openworld.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>
What we've done in the past is just run the dump file through iconv - this has
support for IBM-850.
http://www.gnu.org/software/libiconv/documentation/libiconv/iconv.1.html
Hope this helps,
Michael
Dario V. Fassi wrote:
>
> 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).
>>
>> regards, tom lane
>>
>>
> Ok, I'm interested is do that , but someone is the development group
> would give me some assistence to get a start point to work with.
> I program in Java, C, and less frequently in C++.
>
> Dario.
>
>
--
Web Applications Developer
Open World Ltd, 11 Riverside Court, Riverside Road, Bath, BA2 3DZ.
Tel: +44 1225 444950 Fax: +44 1225 336738 http://www.openworld.co.uk/
CONFIDENTIALITY NOTICE
The information contained in this message is confidential, intended only for
the use of the individual or the entity named as recipient. If the reader of
this message is not that recipient, you are notified that any dissemination,
distribution or copy of this message is strictly prohibited. If you have
received this message in error, please immediately notify us by telephone on
the number above. Your co-operation is appreciated.
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: mstephenson@openworld.org, software@sistemat.com.ar, pgsql-jdbc@postgresql.org
Subject: Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE
In-Reply-To: <40FBA1AD.2050904@openworld.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