Обсуждение: Problem with "z_" in Unicode-DB

Hi,

i have following problem:

I created a database with encoding UNICODE

CREATE DATABASE elements
  WITH ENCODING = 'UNICODE';


In this db there is a table "tblassets"

CREATE TABLE public.tblassets
(
  id serial NOT NULL,
  uri text NOT NULL,
  CONSTRAINT tblassets_pkey PRIMARY KEY (id)
) WITHOUT OIDS;


When i try to execute this select, i get an error:

Statement:
SELECT ID FROM tblAssets WHERE uri like
'/files/AssetStore/postgreSqlTest/ratz_ruebe.jpg' ;

Error:
ERROR:  Invalid UNICODE character sequence found (0xc000)


If I try this, there is no error:

SELECT ID FROM tblAssets WHERE uri like
'/files/AssetStore/postgreSqlTest/ratzruebe.jpg' ;
SELECT ID FROM tblAssets WHERE uri like
'/files/AssetStore/postgreSqlTest/raty_ruebe.jpg' ;

Has PostgreSQL a problem with the characters "z_"?

Platform is:
Redhat 8.0 (english)
PostgreSQL 7.3.3 (redhat binaries)
Client pgAdmin3

Regards, Daniel

On Tuesday 01 July 2003 11:01, Wehrle, Daniel wrote:
> Hi,
>
> i have following problem:
>
(...)
> When i try to execute this select, i get an error:
>
> Statement:
> SELECT ID FROM tblAssets WHERE uri like
> '/files/AssetStore/postgreSqlTest/ratz_ruebe.jpg' ;
>
> Error:
> ERROR:  Invalid UNICODE character sequence found (0xc000)
>
>
> If I try this, there is no error:
>
> SELECT ID FROM tblAssets WHERE uri like
> '/files/AssetStore/postgreSqlTest/ratzruebe.jpg' ;
> SELECT ID FROM tblAssets WHERE uri like
> '/files/AssetStore/postgreSqlTest/raty_ruebe.jpg' ;
>
> Has PostgreSQL a problem with the characters "z_"?

I would doubt it. Can you reproduce this problem with a
different client, e.g. psql? I have tried using psql on 7.3.2 and 7.4a
but see no problems.


Ian Barwick
barwick@gmx.net

=D0=92 =D0=A1=D1=80=D0=B4, 02.07.2003, =D0=B2 00:27, Ian Barwick =D0=BF=D0=
=B8=D1=88=D0=B5=D1=82:
> On Tuesday 01 July 2003 11:01, Wehrle, Daniel wrote:
> >
> > Statement:
> > SELECT ID FROM tblAssets WHERE uri like
> > '/files/AssetStore/postgreSqlTest/ratz_ruebe.jpg' ;
> >
> > ERROR:  Invalid UNICODE character sequence found (0xc000)
> >
> > Has PostgreSQL a problem with the characters "z_"?
>=20
> I would doubt it. Can you reproduce this problem with a=20
> different client, e.g. psql? I have tried using psql on 7.3.2 and 7.4a
> but see no problems.

I can reproduce this with 7.3.3 using psql. I can't with 7.4devel.

--=20
Markus Bertheau.
Berlin, Berlin.
Germany.