Re: Weird characters saved in SQL file

From: "Dave Page" <dpage(at)postgresql(dot)org>
To: "John DeSoi" <desoi(at)pgedit(dot)com>
Cc: "Charlie Clark" <charlie(at)begeistert(dot)org>, "Scott Sturgeon" <sturgeon(at)nettwerk(dot)com>, pgadmin-support(at)postgresql(dot)org
Subject: Re: Weird characters saved in SQL file
Date: 2007-09-23 10:20:44
Message-ID: 200709231120440000@2346923262
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

> ------- Original Message -------
> From: John DeSoi <desoi(at)pgedit(dot)com>
> To: Charlie Clark <charlie(at)begeistert(dot)org>
> Sent: 22/09/07, 20:30:45
> Subject: Re: [pgadmin-support] Weird characters saved in SQL file
>
> On Sep 22, 2007, at 10:15 AM, Charlie Clark wrote:
>
> > <EF><BB><BF> to be precise. Certainly confuses the shell, less does
> > not recognise the file as a text file. I don't know whether this a
> > cookie which associates the file with pgAdmin but I don't really
> > think it's a bug.
>
>
> I think what you are seeing is a unicode byte order mark (BOM):

Sounds like it - it does write them.

Under File->Options you can turn off UTF-8 mode. Try that to confirm what's happening.

Regards, Dave

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2007-09-24 08:04:11 Re: 1.8-Beta5 Bug: sequence properties dialog produces wrong sql statement order
Previous Message John DeSoi 2007-09-22 19:30:45 Re: Weird characters saved in SQL file