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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

On Tuesday 01 July 2003 11:01, Wehrle, Daniel wrote:
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 (AT) gmx (DOT) net



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

=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:
I can reproduce this with 7.3.3 using psql. I can't with 7.4devel.

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

On Wednesday 02 July 2003 00:37, Markus Bertheau wrote:
Hmm. Have just installed 7.3.3 from source but still cannot reproduce the
problem.

Any takers?


Ian Barwick
barwick (AT) gmx (DOT) net

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html