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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend