Re: Weird characters saved in SQL file - Mailing list pgadmin-support

From John DeSoi
Subject Re: Weird characters saved in SQL file
Date
Msg-id 8CB9CE75-A603-4FF3-9498-1F2C2F0F4B42@pgedit.com
Whole thread Raw
In response to Re: Weird characters saved in SQL file  (Charlie Clark <charlie@begeistert.org>)
List pgadmin-support
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):

http://en.wikipedia.org/wiki/Byte_Order_Mark

I don't know what encoding pgAdmin is using, but if it is UTF-8 then  
there is probably no reason to have it. Or at least there needs to be  
preference to leave it out.




John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL



pgadmin-support by date:

Previous
From: "Daniel B. Thurman"
Date:
Subject: Re: 1 Master and 2 Slaves... (Replication)
Next
From: "Dave Page"
Date:
Subject: Re: Weird characters saved in SQL file