Search Postgresql Archives

Re: What encoding to use for this error?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thank you.  I'll take a look at our data export function.

Tom Lane wrote:

Patrick Hatcher <pathat@xxxxxxxxxxx> writes:


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""



Do you have client_encoding set properly while doing the import? If the incoming data is LATIN1, you need to say so, so that the backend knows how to convert it to UNICODE.

			regards, tom lane




---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux