Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #2116: Searching text fields does not work in EUC_JP - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2116: Searching text fields does not work in EUC_JP
Date
Msg-id 15798.1134669854@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2116: Searching text fields does not work in EUC_JP  ("Jon Keating" <jon_keating@gcnet.co.jp>)
Responses Re: BUG #2116: Searching text fields does not work in EUC_JP
List pgsql-bugs
Tree view 
"Jon Keating" <jon_keating@gcnet.co.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #2117: inconsistency in sum
Next
From: Michael Fuhr
Date:
Subject: Re: BUG #2117: inconsistency in sum