| From: | Xavier Poinsard <xpoinsard(at)openpricer(dot)com> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE |
| Date: | 2004-07-19 12:46:18 |
| Message-ID: | cdgfqq$vmn$1@sea.gmane.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-jdbc pgsql-sql |
Dario V. Fassi a écrit :
>
> 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).
>>
did you try the recode utility ?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tsirkin Evgeny | 2004-07-19 15:01:14 | Re: inheritance question |
| Previous Message | Michael Stephenson | 2004-07-19 10:25:49 | Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Jowett | 2004-07-19 23:53:36 | patch: support older junit versions |
| Previous Message | Michael Stephenson | 2004-07-19 10:25:49 | Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kemin Zhou | 2004-07-19 18:54:04 | C++ interface problem with libpq.so.3 |
| Previous Message | Alexander M. Pravking | 2004-07-19 10:46:46 | Re: Problem in age on a dates interval |