From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
Cc: | peter_e(at)gmx(dot)net, barry(at)xythos(dot)com, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: OCTET_LENGTH is wrong |
Date: | 2001-11-23 15:50:14 |
Message-ID: | 6071.1006530614@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> writes:
> 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.
That in itself would not get the job done; how is the sort operator
to know what collation order you want?
The SQL92 spec suggests that the syntax should be
... ORDER BY text_column COLLATE French;
(note collation names are not standardized AFAICT). Seems to me it
should then be the system's responsibility to make this happen,
including any encoding conversion that might be needed before the
comparisons could be done.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Lamar Owen | 2001-11-23 15:54:59 | Re: v7.2b3 packages rebuilt ... |
Previous Message | Lamar Owen | 2001-11-23 15:26:54 | Re: v7.2b3 packaged, but not announced beyond here yet ... |