From: | Gevik Babakhani <pgdev(at)xs4all(dot)nl> |
---|---|
To: | Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Strange query results with invalid multibyte |
Date: | 2006-09-27 14:45:45 |
Message-ID: | 1159368345.11973.35.camel@voyager.truesoftware.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Joost. (hoe gaat het ermee?)
I would like to test this too. Could you please provide the data you are
inserting into the database.
Regards,
Gevik
On Wed, 2006-09-27 at 13:13 +0200, Joost Kraaijeveld wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
--
Regards,
Gevik Babakhani
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Nasby | 2006-09-27 14:46:58 | Re: Sockets and posgtres |
Previous Message | Rafal Pietrak | 2006-09-27 14:28:37 | postgress 8.1.4 deadlocking?? |