Problem with "z_" in Unicode-DB

Поиск
Список
Период
Сортировка
От Wehrle, Daniel
Тема Problem with "z_" in Unicode-DB
Дата
Msg-id 062EDF01BFB4D4118A680000F6E60B0E0364700B@edz-mail.edz.de
обсуждение исходный текст
Ответы Re: Problem with "z_" in Unicode-DB  (Ian Barwick <barwick@gmx.net>)
Список 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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Curt Sampson
Дата:
Сообщение: pg_dump -t option doesn't take schema-qualified table names
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump -t option doesn't take schema-qualified table names