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

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-jdbcpgsql-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

pgsql-sql by date

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

pgsql-admin by date

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

pgsql-jdbc by date

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

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