В Срд, 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/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. > > Hmm. Have just installed 7.3.3 from source but still cannot reproduce the > problem.
Can you try to initdb in some UTF-8 locale? Then the following script triggers the error for me: create database unicodedebug with encoding='unicode'; \c unicodedebug create table a (a text); select * from a where a like 'z_'; I use gcc 3.2.2 and glibc 2.3.1. -- Markus Bertheau. Berlin, Berlin. Germany. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
