Re: [BUGS] Problem with "z_" in Unicode-DB

2003-07-02 Thread Markus Bertheau
В Срд, 02.07.2003, в 23:17, Ian Barwick пишет: > On Wednesday 02 July 2003 00:37, Markus Bertheau wrote: > > В Срд, 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/A

Re: [BUGS] Problem with "z_" in Unicode-DB

2003-07-02 Thread Ian Barwick
On Wednesday 02 July 2003 00:37, Markus Bertheau wrote: > В Срд, 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' ; > > > > > > ERRO

Re: [BUGS] Problem with "z_" in Unicode-DB

2003-07-01 Thread Markus Bertheau
В Срд, 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

Re: [BUGS] Problem with "z_" in Unicode-DB

2003-07-01 Thread Ian Barwick
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 c

[BUGS] Problem with "z_" in Unicode-DB

2003-07-01 Thread Wehrle, Daniel
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) ) WITH