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