Hannu Krosing <[EMAIL PROTECTED]> writes: >> It's been suggested that we could use <wctype.h> where available. >> However there are a bunch of issues that would have to be solved to make >> that happen. (How do we convert between the database character encoding >> and the wctype representation?
> How do we do it for sorting ? We don't --- strcoll() handles it all internally. > It seems inconsistent that we do use locale-aware sorts but not > upper/lower. We do have locale-aware upper/lower ... but only in single-byte encodings. I think it works for the 7-bit-ASCII subset of multibyte encodings, too. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match