Re: Support UTF-8 files with BOM in COPY FROM - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Support UTF-8 files with BOM in COPY FROM
Date
Msg-id 1317133297.10184.1.camel@fsopti579.F-Secure.com
Whole thread Raw
In response to Re: Support UTF-8 files with BOM in COPY FROM  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Support UTF-8 files with BOM in COPY FROM
List pgsql-hackers
On mån, 2011-09-26 at 21:49 +0300, Peter Eisentraut wrote:
> If I store a BOM in row 1, column 1 of my table, because,
> well, maybe it's an XML document or something, then it needs to be
> able to survive a copy out and in.  The only way we could proceed with
> this would be if we prohibited BOMs in all user-data. 

Alternative consideration: We could allow this in CSV format if we made
users quote the first value if it starts with a BOM.  This might be a
reasonable way to get MS compatibility.



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: the big picture for index-only scans
Next
From: Alvaro Herrera
Date:
Subject: Re: Postgresql parser