| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | John Gage <jsmgage(at)numericable(dot)fr> |
| Cc: | Scott Mead <scott(dot)lists(at)enterprisedb(dot)com>, Postgres General Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Identical command-line command will not work with \i metacommand and filename |
| Date: | 2010-04-22 07:37:56 |
| Message-ID: | 4BCFFCD4.7010601@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-general |
On 22/04/10 08:24, John Gage wrote:
> Yeesh. What the ding-dong is this?
>
> JohnGage:EFNWebsite johngage$ od -a CopySql.sql
> 0000000 ? ? ? s e l e c t sp * sp f r o m
> 0000020 sp m e s h _ d e s c r i p t o r
> 0000040 s ; nl nl
>
> What are the ?'s. Mon Dieu, what is going on?
http://en.wikipedia.org/wiki/Byte_order_mark
Tends to get added if you go through a Windows system. Useless for utf-8
afaik. Confuse the hell out of you because various tools parse and hide
them then you pipe the file to a script and everything falls over.
Bunch of scripts available here to remove them:
http://www.xs4all.nl/~mechiel/projects/bomstrip/
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Gage | 2010-04-22 07:48:48 | Re: Identical command-line command will not work with \i metacommand and filename |
| Previous Message | John Gage | 2010-04-22 07:25:30 | Re: Identical command-line command will not work with \i metacommand and filename |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Gage | 2010-04-22 07:48:48 | Re: Identical command-line command will not work with \i metacommand and filename |
| Previous Message | Dave Page | 2010-04-22 07:35:24 | Re: installation on vista |