| Lists: | pgsql-bugs |
|---|
| 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 |
| 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: | Ian Barwick <barwick(at)gmx(dot)net> |
|---|---|
| To: | "Wehrle, Daniel" <daniel(dot)wehrle(at)realcontent(dot)de>, "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: Problem with "z_" in Unicode-DB |
| Date: | 2003-07-01 22:27:16 |
| Message-ID: | 200307020027.16602.barwick@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
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(at)gmx(dot)net
| From: | Markus Bertheau <twanger(at)bluetwanger(dot)de> |
|---|---|
| To: | Ian Barwick <barwick(at)gmx(dot)net> |
| Cc: | "Wehrle, Daniel" <daniel(dot)wehrle(at)realcontent(dot)de>, "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: Problem with "z_" in Unicode-DB |
| Date: | 2003-07-01 22:37:13 |
| Message-ID: | 1057099033.2509.71.camel@saphir |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
В Срд, 02.07.2003, в 00:27, Ian Barwick пишет:
> 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_"?
>
> 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.
I can reproduce this with 7.3.3 using psql. I can't with 7.4devel.
--
Markus Bertheau.
Berlin, Berlin.
Germany.