Search Postgresql Archives

Re: problem converting database to UTF-8

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux