Subject | Problem with COLLATE EN_UK |
---|---|
Author | artlooksoftware |
Post date | 2005-10-12T09:46:35Z |
My database is set to use ISO8859_1. With the following sql select
statement
select * from ATABLE order by AFIELD collate en_uk
the sorted fields are somewhat erratic. For example:
Brown, Douglas
Browne, David
Brown, Fiona
Is this a bug or am I misunderstanding something? Sort is correct with
EN_US
but then foreign names with accented characters are wrongly sorted.
My firebird version info is as follows:
Server Version: WI-V6.2.972 Firebird 1.0.3
Server Implementation: Firebird/x86/Windows NT
Service Version: 2
Jonathan Hyams
statement
select * from ATABLE order by AFIELD collate en_uk
the sorted fields are somewhat erratic. For example:
Brown, Douglas
Browne, David
Brown, Fiona
Is this a bug or am I misunderstanding something? Sort is correct with
EN_US
but then foreign names with accented characters are wrongly sorted.
My firebird version info is as follows:
Server Version: WI-V6.2.972 Firebird 1.0.3
Server Implementation: Firebird/x86/Windows NT
Service Version: 2
Jonathan Hyams