Dataset.Sort and scandic characters



Hi,
I 've been working on changing the database connection from BDE to
ADO and bumpped into a problem with Dataset.Sort as it behaves
differently in Windows XP(sp2) and Windows 2000(sp4) when sorting
stringfields that contain scandic characters.
In Windows 2000; setting e.g. Dataset.Sort := 'lastName', results
in ( Äijälä, Autio, Koivu, Turku) and setting Dataset.Sort := '
', results in (Autio, Koivu, Turku, Äijälä)
whilest
In Windows XP; setting e.g. Dataset.Sort := 'lastName', results in
(Autio, Koivu, Turku, Äijälä) and setting Dataset.Sort := ' ',
results (Autio, Koivu, Turku, Äijälä)

The database is Sql Server 2000 and used collation
Sql_SwedishStd_Pref_CP1_CI_AS. On both workstations there is Mdac2.8
sp1. Development environment is Delphi 6 sp2.

Does anybody know of what this is all about and Is there a way to use
DataSet.Sort and get the correct result in Windows 2000.

Tia,

Heidi

.