Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group