Subject Problem with COLLATE EN_UK
Author artlooksoftware
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