Re: OCTET_LENGTH is wrong
От | Peter Eisentraut |
---|---|
Тема | Re: OCTET_LENGTH is wrong |
Дата | |
Msg-id | Pine.LNX.4.30.0111231810000.763-100000@peter.localdomain обсуждение исходный текст |
Ответ на | Re: OCTET_LENGTH is wrong (Tatsuo Ishii <t-ishii@sra.co.jp>) |
Ответы |
Re: OCTET_LENGTH is wrong
|
Список | pgsql-hackers |
Tatsuo Ishii writes: > > problems. For instance, I don't know if the convert() function would make > > sense then. (Does it even make sense now?) > > Yes. Consider you have UNICODE database and want to sort by French or > whatever LATIN locale. > > SELECT * FROM t1 ORDER BY convert(text_column,'LATIN1'); > > would be the only way to accomplish that. I don't think so. The sort order is independent of the character encoding, and vice versa. It must be, because 1) One language can be represented in different encodings and should obviously still sort the same. 2) One encoding can serve for plenty of languages, which all sort differently. -- Peter Eisentraut peter_e@gmx.net
В списке pgsql-hackers по дате отправления: