Re: pgsql cannot read utf8 files moved from windows correctly!

From: "Trevor Talbot" <quension(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pgsql cannot read utf8 files moved from windows correctly!
Date: 2007-12-23 22:07:44
Message-ID: 90bce5730712231407p42ac0d61x8f638fd13ffec75b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/23/00, Martin Gainty <mgainty(at)hotmail(dot)com> wrote:

> the specifics..
>
> Some byte oriented protocols expect ASCII characters at the beginning of a
> file.
> If UTF-8 is used with these protocols, use of the BOM as encoding form
> signature should be avoided.

Sure, but that isn't true of generic text files, which is one of the
major applications of a UTF-8 BOM. Especially when said text files are
being fed to something that understands multiple encodings. The other
items on that page say as much...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma Jr 2007-12-23 23:35:59 Re: Constraint Trigger's referenced_table
Previous Message Tom Lane 2007-12-23 19:25:27 Re: postgres UTC different from perl?