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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dario V(dot) Fassi" <software(at)sistemat(dot)com(dot)ar>
Cc: Oliver Jowett <oliver(at)opencloud(dot)com>, 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-18 06:29:04
Message-ID: 28179.1090132144@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-jdbcpgsql-sql
"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

In response to

Responses

pgsql-sql by date

Next:From: Peter EisentrautDate: 2004-07-18 08:28:06
Subject: Re: [JDBC] [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE
Previous:From: Andrew LazarusDate: 2004-07-18 02:00:38
Subject: Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE

pgsql-admin by date

Next:From: Mark KirkwoodDate: 2004-07-18 06:48:09
Subject: Re: PITR COPY Failure (was Point in Time Recovery)
Previous:From: Tom LaneDate: 2004-07-18 06:15:34
Subject: Re: PITR COPY Failure (was Point in Time Recovery)

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2004-07-18 06:59:50
Subject: Re: psql-like pure Java client
Previous:From: Blaine SimpsonDate: 2004-07-18 04:10:22
Subject: psql-like pure Java client

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