BUG #1623: COPY and unicode
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.
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