Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Weird characters saved in SQL file
- From: John DeSoi <desoi(at)pgedit(dot)com>
- To: Charlie Clark <charlie(at)begeistert(dot)org>
- Cc: Scott Sturgeon <sturgeon(at)nettwerk(dot)com>, pgadmin-support(at)postgresql(dot)org
- Subject: Re: Weird characters saved in SQL file
- Date: Sat, 22 Sep 2007 15:30:45 -0400
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_MarkI 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
- References:
- Weird characters saved in SQL file
- From: Scott Sturgeon
- Re: Weird characters saved in SQL file
- From: Charlie Clark
- Weird characters saved in SQL file
- Prev by Date: Re: 1 Master and 2 Slaves... (Replication)
- Next by Date: Re: Weird characters saved in SQL file
- Previous by thread: Re: Weird characters saved in SQL file
- Next by thread: Re: Weird characters saved in SQL file
- Indexes: