> Harry Mantheakis wrote:
> >>Correct. The lesson is, never use locale support for Asian languages
> >>and multibyte encodings including UTF-8.
> >
> >
> > Thank you for your reply - much appreciated.
> >
> > I'm now concerned if and how this will affect ORDER BY query results (and
> > other functions) with respect to Latin-1 names and words.
> >
> > I think I'll have to suck it and see, and then post my results - but that
> > won't be until after this next week-end.
>
> C locale and en_* locales give different ordering (at least under Linux).
> The en_* ordering is case insensitive, and the C locale ordering is case
> sensitive because it is simply comparing the ASCII codes.
You could use lower/upper to get case insensitive ordering with C locale.
--
Tatsuo Ishii
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
