Re: problem converting database to UTF-8 - Mailing list pgsql-general

From Vladimir Konrad
Subject Re: problem converting database to UTF-8
Date
Msg-id 20090122221851.6752bd8a@svr0.h.dearm.co.uk
Whole thread Raw
In response to Re: problem converting database to UTF-8  (Alan Hodgson <ahodgson@simkin.ca>)
List pgsql-general
> > 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.

Just found an alternative - "uconv" command (part of ICU project):

http://www.icu-project.org/userguide/intro.html

(not sure if it is in debian, but it does not buffer entire file when
used in a pipe).

Vlad

pgsql-general by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: problem converting database to UTF-8
Next
From: Ivan Sergio Borgonovo
Date:
Subject: very long update gin index troubles back?