Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #1623: COPY and unicode - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: BUG #1623: COPY and unicode
Date
Msg-id 200504251559.j3PFxqn23774@candle.pha.pa.us
Whole thread Raw
In response to BUG #1623: COPY and unicode  ("Diarmaid Foley" <foleydiarmaid@yahoo.com>)
List pgsql-bugs
Tree view 
Diarmaid Foley wrote:
>
> The following bug has been logged online:
>
> Bug reference:      1623
> Logged by:          Diarmaid Foley
> Email address:      foleydiarmaid@yahoo.com
> PostgreSQL version: 8.0.1
> Operating system:   Windows XP professional
> Description:        COPY and unicode
> Details:
>
> The COPY command for loading data does not support data containing extended
> unicode characters. For example: the ñ in España (U00F1). This is very
> important feature that should exist as standard in any data loading
> facility.

Yes, this is a known problem.  We support UTF8 but Win32 only supports
UTF16.  We are going to try to fix this for 8.1.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-bugs by date:

Previous
From: "Diarmaid Foley"
Date:
Subject: BUG #1623: COPY and unicode
Next
From: Kris Jurka
Date:
Subject: Re: BUG #1624: connect uses properties before URL