unicode and = - Mailing list pgsql-general

From Grant Morgan
Subject unicode and =
Date
Msg-id op.ssm8s7zbuogdv0@localhost.localdomain
Whole thread Raw
Responses Re: unicode and =
List pgsql-general
= is not working on a char(30) coloumn for me.
I want to find rows with equal name.
I have my database set to unicode.

SQL1
SELECT h1.key,h1.name,h2.key,h2.name
 FROM table1 as h1, table1 as h2
WHERE h1.name=h2.name
and h1.OID = 730716

produces result rows where name doe not match
name is multibyte UTF-8 values.

SQL1
SELECT h1.key,h1.name,h2.key,h2.name
 FROM table1 as h1, table1 as h2
WHERE h1.key=h2.key
and h1.OID = 730716

produces correct results.
key is single byte UTF-8 values only (digits only)

I have a hash index on name, I dropped it and got a different but still wrong result.
key is part of a multicolumn primary kay

version 8.0.3 - gcc 3.4.3 fedora 3

Any suggestion on how to match multibyte characters? Do I need to use a differnt comparison operator?

Thanks,
Grant

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: subqueries
Next
From: Tom Lane
Date:
Subject: Re: Insert behavior in transaction