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

From John R Pierce
Subject Re: Using psql -f to load a UTF8 file
Date
Msg-id 505BEF6C.9000509@hogranch.com
Whole thread Raw
In response to Re: Using psql -f to load a UTF8 file  (Alan Millington <admillington@yahoo.co.uk>)
Responses Re: Using psql -f to load a UTF8 file
List pgsql-general
On 09/20/12 10:27 AM, Alan Millington wrote:
> I am using Notepad, which inserts the byte order mark. Following the
> links a bit further, I gather that the version of Notepad that I am
> using may not identify a UTF8 file correctly if the byte order mark is
> omitted. Also, as I mentioned, Python makes use of it. (From the
> Python documentation on Encoding declarations: "If the first bytes of
> the file are the UTF-8 byte-order mark ('\xef\xbb\xbf'), the declared
> file encoding is UTF-8 (this is supported, among others, by
> Microsoft’s Notepad).")

I've never seen Notepad generate UTF8.   Usually its either 8 bit ASCII
(ISO8559-1 or something), or its UTF16 aka "Unicode".



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast




pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: foreign key from array element
Next
From: Chris Angelico
Date:
Subject: Re: Using psql -f to load a UTF8 file