| From: | David Goodenough <david(dot)goodenough(at)btconnect(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: problem converting database to UTF-8 |
| Date: | 2009-01-22 20:59:56 |
| Message-ID: | 200901222059.57790.david.goodenough@btconnect.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thursday 22 January 2009, Vladimir Konrad 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...
>
> V
You have not understood what I said. I ran iconv, and it changes the
encoding of the data, but not the ENCODING= statements that are
embedded in the datastream. Yes I can change those with sed, but
I do not know what else I need to change. There must be an easier
way.
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vladimir Konrad | 2009-01-22 21:09:56 | Re: problem converting database to UTF-8 |
| Previous Message | Alan Hodgson | 2009-01-22 20:56:49 | Re: problem converting database to UTF-8 |