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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [JDBC] [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE
Дата
Msg-id 28179.1090132144@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: [JDBC] [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE  ("Dario V. Fassi" <software@sistemat.com.ar>)
Список pgsql-sql
"Dario V. Fassi" <software@sistemat.com.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

В списке pgsql-sql по дате отправления:

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Re: Query plan discrepancies
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: [JDBC] [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE