Re: unicode and =

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Grant Morgan" <grant(at)ryuuguu(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: unicode and =
Date: 2005-06-20 01:13:39
Message-ID: 17441.1119230019@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Grant Morgan" <grant(at)ryuuguu(dot)com> writes:
> = 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.

I'll bet you are running the postmaster in a locale that isn't expecting
utf-8 encoding. The locale and encoding have to match or you're going
to get very strange behavior.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lee Harr 2005-06-20 01:19:05 plpgsql constraint checked data fails to restore
Previous Message Tom Lane 2005-06-20 01:08:54 Re: Insert behavior in transaction