Thread: Unicode errors?

Unicode errors?

From

mixo

Date:

04 July 2003, 07:34:33

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@host.name": can't parse "@host.name"
++++++++++++++++++++++++

Others unicode numbers and email addresses have been logged.
The were proplems with the data import before, I got :
    ++++++++++++++++++++++++
   Wide character in subroutine entry at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Encode.pm
   ++++++++++++++++++++++++
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)

Re: Unicode errors?

From

Richard Huxton

Date:

04 July 2003, 08:06:30

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@host.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