Re: BUG #1623: COPY and unicode

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