From: | "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Strange query results with invalid multibyte character |
Date: | 2006-09-27 11:13:54 |
Message-ID: | A3D1526C98B7C1409A687E0943EAC410605FDD@obelix.askesis.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I have a strange problem.
I have 2 database, both created with:
CREATE DATABASE muntdev WITH OWNER = postgres ENCODING = 'UTF8' TABLESPACE = pg_default;
Running the queries below on the first database is OK and do what I expect.
If I create a backup of the first datase and restore that backup in the second database the following happens:
The first query (see below) returns 17 records, all containing 'Boonk%'.
The second query (see below)returns 'ERROR: invalid multibyte character for locale'
Query 1:
select lastname from salesordercustomer where lower(lastname) like 'boonk%'
Query 2:
select lastname from salesordercustomer where upper(lastname) like 'BOONK%'
Both database are running *exactly* the same version of Debian Etch AMD64 and *exactly* the same version of PostgreSQL (8.1.4 for AMD64) ....
Can anyone explain this to me?
TIA
Joost
From | Date | Subject | |
---|---|---|---|
Next Message | Asok Chattopadhyay | 2006-09-27 11:34:58 | Re: Transaction is read-only in auto commit mode |
Previous Message | Alban Hertroys | 2006-09-27 10:37:23 | reply-to address broken (Was: Re: postgresql ddl scripts - drop object fails entire script) |