Re: Problem with "z_" in Unicode-DB

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