Re: Using psql -f to load a UTF8 file

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Using psql -f to load a UTF8 file
Date: 2012-09-20 18:33:09
Message-ID: 505B6165.9030701@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Benedikt Grundmann 2012-09-20 18:36:29 Expression to construct a anonymous record with named columns?
Previous Message Adrian Klaver 2012-09-20 17:53:07 Re: Using psql -f to load a UTF8 file