Re: Invalid byte sequence for encoding "UTF8": 0xedbebf

From: BRUSSER Michael <Michael(dot)BRUSSER(at)3ds(dot)com>
To: Alan Hodgson <ahodgson(at)simkin(dot)ca>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Invalid byte sequence for encoding "UTF8": 0xedbebf
Date: 2011-06-15 21:44:10
Message-ID: 29EA9BFEF7E7FC4F988818CA0C5C78C20F6A2733@AG-DCC-MBX03.dsone.3ds.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Alan Hodgson
Sent: Wednesday, June 15, 2011 5:37 PM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Invalid byte sequence for encoding "UTF8": 0xedbebf

On June 15, 2011 01:18:27 PM BRUSSER Michael wrote:
> Unless there's no other options I don't want to use sed or break file into
> pieces, if possible,

--------------------------------------------------

>> iconv loads everything into RAM. You can use "split", convert the pieces, and
>> then recombine, I did that when converting a large database to utf-8 and it
>> worked.

-------------------------------------------------

- Thanks, but this is exactly what I am trying to avoid!
Using split is good if you have one database to upgrade and no external customers.
(Not to mention other problems with this approach)

This email and any attachments are intended solely for the use of the individual or entity to whom it is addressed and may be confidential and/or privileged.

If you are not one of the named recipients or have received this email in error,

(i) you should not read, disclose, or copy it,

(ii) please notify sender of your receipt by reply email and delete this email and all attachments,

(iii) Dassault Systemes does not accept or assume any liability or responsibility for any use of or reliance on this email.

For other languages, go to http://www.3ds.com/terms/email-disclaimer

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Matthew A. R. Sherian 2011-06-15 22:03:16 Further details on cursors.
Previous Message Alan Hodgson 2011-06-15 21:37:21 Re: Invalid byte sequence for encoding "UTF8": 0xedbebf