Search Postgresql Archives

Re: Using psql -f to load a UTF8 file

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

 



On 09/20/2012 10:27 AM, Alan Millington wrote:
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.

The problem is Notepad has a limited view of the text world. If you use it only in the Microsoft universe and for simple tasks it is sufficient. The issues arise when you try to work with files outside that scope. For long term peace of mind you will better served by more capable text editors(see other posts for suggestions). As to the Python documentation, it goes on to say:

http://docs.python.org/tutorial/interpreter.html#source-code-encoding

"Notice that this signature is not understood in older Python releases (2.2 and earlier), and also not understood by the operating system for script files with #! lines (only used on Unix systems)."


From the Zen of Python:
"Explicit is better than implicit"

Following that the preferred way of declaring an encoding would be:
# -*- coding: utf-8 -*-

See the above link for more information.




--
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


[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