From: | "Wehrle, Daniel" <daniel(dot)wehrle(at)realcontent(dot)de> |
---|---|
To: | "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Problem with "z_" in Unicode-DB |
Date: | 2003-07-01 09:01:32 |
Message-ID: | 062EDF01BFB4D4118A680000F6E60B0E0364700B@edz-mail.edz.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-07-01 13:44:17 | Re: pg_dump -t option doesn't take schema-qualified table names |
Previous Message | Alejandro Delu | 2003-06-30 21:36:38 | problems... |