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(at)yahoo(dot)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 Espaa (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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073