Re: UTF8 with BOM support in psql

Andrew Dunstan <andrew@dunslane.net>

From: Andrew Dunstan <andrew@dunslane.net>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>, pgsql-hackers@postgresql.org
Date: 2009-10-21T13:08:23Z
Lists: pgsql-hackers

Peter Eisentraut wrote:
> On Wed, 2009-10-21 at 13:11 +0900, Itagaki Takahiro wrote:
>   
>> The attached patch replace BOM with while spaces, but it does not
>> change client encoding automatically. I think we can always ignore
>> client encoding at the replacement because SQL command cannot start
>> with BOM sequence. If we don't ignore the sequence, execution of
>> the script must fail with syntax error.
>>     
>
> I feel that psql is the wrong place to fix this.  BOMs in UTF-8 should
> be ignored everywhere, all the time.
>
>   

I suggest you re-read the Unicode FAQ on the subject.  That is not the 
conclusion I came to after I read it. Quite the reverse in fact.

cheers

andrew