| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-jdbc pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Kirkwood | 2004-07-18 06:48:09 | Re: PITR COPY Failure (was Point in Time Recovery) |
| Previous Message | Tom Lane | 2004-07-18 06:15:34 | Re: PITR COPY Failure (was Point in Time Recovery) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Jowett | 2004-07-18 06:59:50 | Re: psql-like pure Java client |
| Previous Message | Blaine Simpson | 2004-07-18 04:10:22 | psql-like pure Java client |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2004-07-18 08:28:06 | Re: [JDBC] [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE |
| Previous Message | Andrew Lazarus | 2004-07-18 02:00:38 | Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE |