Postgres Pro
Downloads
Home   >   mailing lists

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 505B6165.9030701@hogranch.com
Whole thread Raw
In response to Using psql -f to load a UTF8 file  (Alan Millington <admillington@yahoo.co.uk>)
List pgsql-general
Tree view 
On 09/20/12 7:56 AM, Alan Millington wrote:
> I discovered a long time ago that psql does not like UTF8 files: it
> complains about the byte order mark on the first line.

in case it wasn't clear from previous replies, Windows native Unicode
format is NOT UTF8, its UTF16, where every character is stored as 2 bytes.



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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Using psql -f to load a UTF8 file
Next
From: Aleksey Tsalolikhin
Date:
Subject: Why do I have holes in my pages?