Re: Weird characters saved in SQL file

Am 22.09.2007 um 00:01 schrieb Scott Sturgeon:

> Hi,
>
> I'm running pgadmin 1.8.0 Beta 5 (rev: 6630:6631) on Mac OS X
> 10.4.10 against postgresql 8.2.3...
>
> I've written a bunch of table create statements using the SQL
> editor tool and saved them as files... Then I used a php script to
> parse the files and run them against the database in a specific
> order. For some reason, at the beginning of each file are some
> hidden characters... 0xEF. 0xBB & 0xBF respectively. This seems odd
> to me. Of course, it caused errors when sending the contents of the
> files to the database. I'm now removing those characters before
> sending the sql to the database and it works fine now... but a bit
> of a pain in the ass. IMHO, they shouldn't be there in the first
> place. You can't see them when opening the file using pgadmin, but
> if you open the file using vim or something, you will see them there.

<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.

Charlie
--
Charlie Clark
Helmholtzstr. 20
Düsseldorf
D- 40215
Tel: +49-211-938-5360
GSM: +49-178-782-6226