Re: OCTET_LENGTH is wrong - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: OCTET_LENGTH is wrong
Date
Msg-id 20011123163439L.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: OCTET_LENGTH is wrong  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: OCTET_LENGTH is wrong
Re: OCTET_LENGTH is wrong
List pgsql-hackers
> 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.
--
Tatsuo Ishii


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Unescaped new lines in postgres
Next
From: Kovacs Zoltan
Date:
Subject: hu.po