Re: [ADMIN] what's the efficient/safest way to convert database character set ?

Поиск
Список
Период
Сортировка
От Huang, Suya
Тема Re: [ADMIN] what's the efficient/safest way to convert database character set ?
Дата
Msg-id D83E55F5F4D99B4A9B4C4E259E6227CD9DF7B4@AUX1EXC01.apac.experian.local
обсуждение исходный текст
Ответ на Re: [ADMIN] what's the efficient/safest way to convert database character set ?  (John R Pierce <pierce@hogranch.com>)
Ответы Re: [ADMIN] what's the efficient/safest way to convert database character set ?  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
Дерево обсуждения 
> We stored ISO-8859-1, do we still need to use iconv to convert the file?

you should be able to do the dump specifying pg_dump
--encoding=iso-8559-1 then restore it to the utf8 database, and postgres will do the conversion for you.

One more question, if the data stored in database including UTF-8 and ISO 8859-1, is that OK to dump them all in
ISO-8859-1?

Thanks,
Suya

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Preserving the source code of views
Следующее
От: John R Pierce
Дата:
Сообщение: Re: [ADMIN] what's the efficient/safest way to convert database character set ?