Re: problem converting database to UTF-8

From: Vladimir Konrad <vk(at)dsl(dot)pipex(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: problem converting database to UTF-8
Date: 2009-01-22 22:18:51
Message-ID: 20090122221851.6752bd8a@svr0.h.dearm.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2009-01-22 23:55:43 very long update gin index troubles back?
Previous Message Daniel Verite 2009-01-22 22:04:58 Re: problem converting database to UTF-8