[GENERAL] unicode and =

2005-06-19 Thread Grant Morgan
= 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 multib

Re: [GENERAL] unicode and =

2005-06-20 Thread Grant Morgan
sorting on this project just equality, but general solution would be apreciated. Thanks, Grant On Mon, 20 Jun 2005 10:13:39 +0900, Tom Lane <[EMAIL PROTECTED]> wrote: "Grant Morgan" <[EMAIL PROTECTED]> writes: = is not working on a char(30) coloumn for me. I want to find rows w