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

From: "Dario V(dot) Fassi" <software(at)sistemat(dot)com(dot)ar>
To: pgsql-sql(at)postgresql(dot)org
Cc: "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 19:47:20
Message-ID: 40FAD3C8.3080503@sistemat.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-jdbc pgsql-sql


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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Randall Perry 2004-07-18 19:52:41 Re: How do I grant access to entire database at
Previous Message Patrice Trognon 2004-07-18 11:27:52 Re: ADMIN Migrate postgres databases from SQL_ASCII to UNICODE

Browse pgsql-jdbc by date

  From Date Subject
Next Message datalines 2004-07-19 08:27:23 Re: JDBC connection issue
Previous Message Blaine Simpson 2004-07-18 14:12:44 Re: psql-like pure Java client

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-07-19 04:23:21 Re: FOR-IN-EXECUTE, why fail?
Previous Message Peter Eisentraut 2004-07-18 08:28:06 Re: [JDBC] [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE