Search Postgresql Archives

Re: Identical command-line command will not work with \i metacommand and filename

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



John Gage wrote:
> > 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/
> 
> Correct.  I found the following via Google.
> "I created a file utf8.rb with this content: C:\>ruby -e "p  
> File.read('utf8.rb')" "\357\273\277puts \"Hello World\""
> The "\357\273\277" part is the Byte Order Mark for UTF-8, my editor  
> automatically put it at the beginning of the file, because I saved it  
> as UTF-8."
> At least it isn't some evil virus.  Have to do Mr. WorkAround now.

FYI, this is fixed in Postgres 9.0:

     Ignore leading UTF-8-encoded Unicode byte-order marker in
     psql (Itagaki Takahiro)

-- 
  Bruce Momjian  <bruce@xxxxxxxxxx>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux