From: | Marian POPESCU <softexpert(at)libertysurf(dot)fr> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | "Invalid multibyte character for locale" still there |
Date: | 2005-01-31 14:22:39 |
Message-ID: | ctlev7$49s$1@sea.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I want to report a bug on PG 8.0 (linux : Fedora Core 3)
A LIKE '%langage C%' in the WHERE clause of my SELECT statement gives
"invalid multibyte character for locale" error.
I thought the bug
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=113231 was fixed
and the patch was incorporated in the mainstream.
Details
-------
In initdb.i18n I have
LANG="en_US"
(I tried also LANG="en_US.UTF-8")
rpm -q postgresql gives postgresql-8.0.0-1PGDG (it's the official
postgresql SRPM that rebuilt with default options).
On /etc/sysconfig/i18n I have tried LANG="en_US" and LANG="en_US.UTF-8"
as well.
Real Query
----------
SELECT t0.id_profile, t0.first_name, t0.last_name, t0.email,
t0.experience, t0.study_level, t0.study_type, t0.compet_type1,
t0.compet_type2, t0.compet_type3, t0.empl_type, t0.avail_type,
t0.prof_salary, t0.comments, t1.srcfileid
FROM cv_profiles t0 LEFT JOIN cv_profiles_ocr t1 ON (t0.id_profile =
t1.id_profile)
WHERE (( upper(t1.ocrcontent) LIKE upper('%langage C%') ) ) ORDER BY
t0.last_name, t0.first_name;
Questions
---------
1. What can I do to outcome this issue (known workarounds, etc.)?
2. Will it be adressed on PG 8.0.1 ?
Thanks,
Marian
From | Date | Subject | |
---|---|---|---|
Next Message | Sven Willenberger | 2005-01-31 15:27:15 | Re: Howto determin the number of elemnts of an array |
Previous Message | Pavel Stehule | 2005-01-31 14:09:46 | conflict types mysql and PostgreSQL |