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

2004-07-18 Thread Dario V. Fassi
Tom Lane wrote: "Dario V. Fassi" <[EMAIL PROTECTED]> 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 Code

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

2004-07-18 Thread Peter Eisentraut
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.

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

2004-07-17 Thread Tom Lane
"Dario V. Fassi" <[EMAIL PROTECTED]> 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 i