Re: BUG #2116: Searching text fields does not work in EUC_JP

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jon Keating" <jon_keating(at)gcnet(dot)co(dot)jp>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2116: Searching text fields does not work in EUC_JP
Date: 2005-12-15 18:04:14
Message-ID: 15798.1134669854@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Jon Keating" <jon_keating(at)gcnet(dot)co(dot)jp> writes:
> I have a database with the default encoding set to EUC_JP and the client
> (using pgAdmin III) is set to EUC_JP as well.

Is the database's locale set to something that works with EUC_JP? You
can't just whack the encoding around without paying attention to having
a compatible locale setting ... and unfortunately, PG doesn't have
enough knowledge about locales to warn you when you choose a combination
that doesn't work.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jim Klo 2005-12-15 19:09:18 Re: plpgsql TEMP table issue not fixed in 8.1?
Previous Message Tom Lane 2005-12-15 18:00:30 Re: BUG #2117: inconsistency in sum