At 01:21 a.m. 28/11/2013, Jacob Havkrog wrote:

>5: Using the syntax
>
>create collation UTF8_DANISH_CI for UTF8 from UNICODE CASE INSENSITIVE 'LOCALE=da_DK';
>
>create collation UTF8_DANISH_CS for UTF8 from UNICODE CASE SENSITIVE 'LOCALE=da_DK';
>
>doesn't give correct ÆØÅ sorting though... Hopefully that's fixed in FB 2.5.3 too.

Did you try including the ACCENT SENSITIVE keyword in either example?


Helen Borrie, Support Consultant, IBPhoenix (Pacific)
Author of "The Firebird Book" and "The Firebird Book Second Edition"
http://www.firebird-books.net
__________________________________________________________________