What encoding to use for this error? - Mailing list pgsql-general

From Patrick Hatcher
Subject What encoding to use for this error?
Date
Msg-id OFF61A487F.F65A12D9-ON88256FDB.004B8B0F-88256FDB.004B8B3F@fds.com
Whole thread Raw
List pgsql-general
We're testing moving our data to UNICODE from LATIN1, but when I try to import my data, I get the following error:
 
DBD::Pg::st execute failed: ERROR:  Unicode characters greater than or equal to
0x10000 are not supported
CONTEXT:  COPY bcp_mdc_products, line 120, column description: "Lladró "Ducks in
 a Basket""

What encoding should I be using for characters like this?  I thought unicode was supposed to handle these types of characters?
 
TIA

Patrick Hatcher

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: very slow after a while...
Next
From: Costin Manda
Date:
Subject: Re: very slow after a while...