Skip site navigation (1) Skip section navigation (2)

Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE

From: Michael Stephenson <mstephenson(at)openworld(dot)org>
To: "Dario V(dot) Fassi" <software(at)sistemat(dot)com(dot)ar>
Cc: pgsql-sql(at)postgresql(dot)org,"pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE
Date: 2004-07-19 10:25:49
Message-ID: 40FBA1AD.2050904@openworld.org (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-jdbcpgsql-sql
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(at)sistemat(dot)com(dot)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.

In response to

pgsql-sql by date

Next:From: Alexander M. PravkingDate: 2004-07-19 10:46:46
Subject: Re: Problem in age on a dates interval
Previous:From: Luis SousaDate: 2004-07-19 09:00:50
Subject: Re: Problem in age on a dates interval

pgsql-admin by date

Next:From: Xavier PoinsardDate: 2004-07-19 12:46:18
Subject: Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE
Previous:From: Simon RiggsDate: 2004-07-19 07:35:05
Subject: Re: [HACKERS] Point in Time Recovery

pgsql-jdbc by date

Next:From: Xavier PoinsardDate: 2004-07-19 12:46:18
Subject: Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE
Previous:From: datalinesDate: 2004-07-19 08:27:23
Subject: Re: JDBC connection issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group