Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Strange query results with invalid multibyte character


  • 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: Wed, 27 Sep 2006 13:13:54 +0200
  • Message-id: <A3D1526C98B7C1409A687E0943EAC410605FDD(at)obelix(dot)askesis(dot)nl>

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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group