From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | mixo <mixo(at)beth(dot)uniforum(dot)org(dot)za>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Unicode errors? |
Date: | 2003-07-04 11:05:46 |
Message-ID: | 200307041205.46115.dev@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Friday 04 Jul 2003 9:48 am, mixo wrote:
> The following message have been reported in the logs during data insertion:
> ++++++++++++++++++++++++
> DBD::Pg::st execute failed: ERROR: Invalid UNICODE character sequence
> found (0xc567)
> DBD::Pg::st execute failed: ERROR: Unicode >= 0x10000
> DBD::Pg::st execute failed: ERROR: pg_atoi: error in
> "0112022200(at)host(dot)name": can't parse "@host.name"
[snip]
> So LANG was set to C, and the problem disappeard.
> What could be the cause of the problem?
>
> perl-5.8.0-88
> perl-DBI-1.32-5
> perl-DBD-Pg-1.21-2
> postgresql-7.3.2-3
> Redhat 9 (2.4.20-8smp)
I think it might well be the known issues with RedHat's recent locale changes
(to unicode) and Perl. Try googling for "redhat perl unicode utf" or similar
- there's been plenty of discussion.
The standard suggestion seems to be to remove the "UTF8" part of the LANG
settings from your RedHat installation.
--
Richard Huxton
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2003-07-04 11:12:25 | Re: PostgreSQL vs. MySQL |
Previous Message | Darko Prenosil | 2003-07-04 10:56:46 | Passing NEW to function |