On 09/20/2012 10:44 AM, Leif Biberg Kristensen wrote:
Torsdag 20. september 2012 19.27.22 skrev Alan Millington :Thank you for the link. 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).") The conclusion seems to be that I must use one editor for Python, and another for Postgres.
I would strongly advise against using Notepad for any kind of text editing. Wordpad works better, or even better yet Notepad ++:
http://notepad-plus-plus.org/
It's been a long time since I last wrote a Python script, but I've always used the explicit encoding directive: #! /usr/bin/env python # -*- encoding: utf-8 -*- See http://docs.python.org/release/2.5.1/ref/encodings.html which also mentions the BOM method as an alternative. regards, Leif
-- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
