Re: Using psql -f to load a UTF8 file - Mailing list pgsql-general

From Leif Biberg Kristensen
Subject Re: Using psql -f to load a UTF8 file
Date
Msg-id 201209201744.59685.leif@solumslekt.org
Whole thread Raw
In response to Using psql -f to load a UTF8 file  (Alan Millington <admillington@yahoo.co.uk>)
Responses Re: Using psql -f to load a UTF8 file
Re: Using psql -f to load a UTF8 file
List pgsql-general
 Torsdag 20. september 2012 16.56.16 skrev Alan Millington :
> psql". But how am I supposed to remove the byte order mark from a UTF8
> file? I thought that the whole point of the byte order mark was to tell
> programs what the file encoding is. Other programs, such as Python, rely
> on this.

http://en.wikipedia.org/wiki/Byte_order_mark

While the Byte Order Mark is important for UTF-16, it's totally irrelevant to
the UTF-8 encoding. Still you'll find several editors that automatically input
BOMs in every text file. There is usually a setting "Insert Byte Order Mark"
somewhere in the configuration, and it may be on by default.

regards, Leif


pgsql-general by date:

Previous
From: Lucas Clemente Vella
Date:
Subject: Re: Passing row set into PL/pgSQL function.
Next
From: Tom Lane
Date:
Subject: Re: Using psql -f to load a UTF8 file