Weird characters saved in SQL file

From: Scott Sturgeon <sturgeon(at)nettwerk(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Weird characters saved in SQL file
Date: 2007-09-21 22:01:04
Message-ID: 46F43F20.8040607@nettwerk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.

Thanks,
Scott

--
Scott Sturgeon <scotts(at)nettwerk(dot)com>
Senior Software Developer
Nettwerk Music Group http://www.nettwerk.com

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Daniel B. Thurman 2007-09-22 01:35:55 Replication Sets
Previous Message Dave Page 2007-09-21 19:45:24 Re: pgadmin3 osx - two issues