How to sort Scandinavian letters using recordsets

Hi!

We're using independent recordsets for various tasks in ASP/VBScript.

Set rsRecords = Server.CreateObject("ADODB.Recordset")

rsRecords.Fields.Append "Name" , adVarChar, 255, adFldUpdatable
rsRecords.Fields.Append "Country", adVarChar, 255, adFldUpdatable

rstRecords.Open , , adOpenDynamic


After populating the recordset with values we apply the Sort method:

Call rsRecords.AddNew()
rsRecords("Name") = "Øystein"
rsRecords("Country") = "USA"
Call rstSortedList.Update()

Call rsRecords.AddNew()
rsRecords("Name") = "Olga"
rsRecords("Country") = "Norway"
Call rstSortedList.Update()

Call rsRecords.AddNew()
rsRecords("Name") = "Petter"
rsRecords("Country") = "USA"
Call rstSortedList.Update()


rstRecords.Sort = "Name"

The order then becomes:

Olga
Øystein
Petter

The Sort method ignores the Norwegian letter "Ø" and treats it like an
"O". The correct order should have been:

Olga
Petter
Øystein

Do you know have we can make the Sort method sort Norwegian letters
correctly?

Thanks!

.