On Tue, 2007-09-11 at 11:53 +0900, Tatsuo Ishii wrote:
> > Isn't the collation a locale issue, not an encoding issue? Is there a
> > ja_JP.UTF-8 that defines the proper order?
>
> I don't think it helps. The point is, he needs different language's
> collation, while PostgreSQL allows only one collation(locale) per
> database cluster.
My thought was: if we had some function that treated a string as a
different locale, it might solve the problem without violating the
database encoding.
Converting to a different encoding, and producing text result, is the
source of the problem.
Regards,Jeff Davis