Re: problem converting database to UTF-8

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: problem converting database to UTF-8
Дата
Msg-id 200901221256.49166@hal.medialogik.com
обсуждение исходный текст
Ответ на Re: problem converting database to UTF-8  (Vladimir Konrad <vk@dsl.pipex.com>)
Ответы Re: problem converting database to UTF-8
Re: problem converting database to UTF-8
Список pgsql-general
On Thursday 22 January 2009, Vladimir Konrad <vk@dsl.pipex.com> wrote:
> > iconv does not change the database encodings embedded in the file
> > (and it is quite large).
>
> Have you read the manual?
>
>        file   A pathname of an input file. If no file operands are
>        specified, or if a file operand is '-', the standard input shall
>        be used.
>
>
> cat the-source-dump.sql | iconv -t utf8 - > my-converted.sql
>
> Size should not matter in this case...

Yeah it does. iconv buffers everything in memory, as I recall.

However, you can "split" the file into manageable pieces, run each through
iconv, and recombine afterwards.


--
Current Peeve: The mindset that the Internet is some sort of school for
novice sysadmins and that everyone -not- doing stupid dangerous things
should act like patient teachers with the ones who are. -- Bill Cole, NANAE

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

Предыдущее
От: Vladimir Konrad
Дата:
Сообщение: Re: problem converting database to UTF-8
Следующее
От: David Goodenough
Дата:
Сообщение: Re: problem converting database to UTF-8