| Subject | Re: [firebird-support] case sensitive "order by" |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2005-04-11T10:34:13Z |
On 11 Apr 2005 at 16:07, Anton Malinovskiy wrote:
about "right" language settings in IB/FB.
In short: you should use case-insensitive collation. Either assign
it to the column or indicate it in ORDER BY clause like this:
ORDER BY name COLLATE PXW_CYRL;
--
SY, Dimitry Sibiryakov.
>But this solution doesn't suit me. Is the any other solution?Go to www.ibase.ru and you'll find everything you need to know
about "right" language settings in IB/FB.
In short: you should use case-insensitive collation. Either assign
it to the column or indicate it in ORDER BY clause like this:
ORDER BY name COLLATE PXW_CYRL;
--
SY, Dimitry Sibiryakov.