> ------- Original Message ------- > From: John DeSoi <[EMAIL PROTECTED]> > To: Charlie Clark <[EMAIL PROTECTED]> > 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match