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

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

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Dario V(dot) Fassi" <software(at)sistemat(dot)com(dot)ar>,Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-sql(at)postgresql(dot)org
Subject: Re: [JDBC] [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE
Date: 2004-07-18 08:28:06
Message-ID: 200407181028.06765.peter_e@gmx.net (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-jdbcpgsql-sql
Dario V. Fassi wrote:
> 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.

If you have a program named "recode" installed you could try using that 
to recode the dump file to a supported encoding.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


In response to

pgsql-sql by date

Next:From: Dario V. FassiDate: 2004-07-18 19:47:20
Subject: Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE
Previous:From: Tom LaneDate: 2004-07-18 06:29:04
Subject: Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE

pgsql-admin by date

Next:From: evgeny tsurkinDate: 2004-07-18 08:46:08
Subject: Re: inheritance question
Previous:From: Mark KirkwoodDate: 2004-07-18 08:05:42
Subject: Re: PITR COPY Failure (was Point in Time Recovery)

pgsql-jdbc by date

Next:From: Blaine SimpsonDate: 2004-07-18 13:47:05
Subject: Re: psql-like pure Java client
Previous:From: Oliver JowettDate: 2004-07-18 06:59:50
Subject: Re: psql-like pure Java client

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