Re: Garbage character inserted at the beginning of every SQL file on OSX

On Wed, Feb 17, 2010 at 10:38 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> All,
>
> Version: 1.10.1
> Platform: OSX 10.5
> Installed From: .dmg
> Severity: Major
> Reproduceable: Always
> Description:
> Every time I create a new SQL file using the SQL editor in pgAdmin, it
> inserts a non-ASCII garbage character at the very beginning of the file.
>  This then prevents the file from running, say through psql.
>
> Sometimes it also inserts the character when I edit an existing file,
> but not always.  I haven't discerned a pattern here.
>
> The character cannot be viewed in emacs, but can be deleted.  This issue
> is completely prohibitive of using the SQL editor in any kind of shared
> system.

It's not garbage, it's a Unicode BOM.

If your other software cannot read Unicode files properly, you can
turn off Unicode file writing under File -> Options.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com