I'm working with Delphi 3 and the BDE and Interbase 4.2.
I create a Database with Default Charset WIN1252 or ISO... for Spanish
sorting.

I create a table CUSTOMERS with a few columns and a primary key...
I create indexes for the columns defined as COLLATE ES_ES or COLLATE
PDW_SPAN (COLUMN NAME)

When I Execute:

// Quick
Customers.indexfieldnames:='CODE';
// Quick
Customers.Open;
// Very Slow on 60.000 records.(30 seconds)
Customers.indexfieldnames:='NAME'

// On locate procedures is also slow if BDE needs to change the active index

// If I Execute a Query it's very quick
SELECT CODE,NAME FROM CUSTOMERS ORDER BY NAME

I tried to change the alias Language driver to Spanish ANSI and others....
If I select NULL alias language driver the characters dont display correctly
and I have errors.

When I use a database created with CHARACTER SET NONE and without any
language driver the same code works fast.

If I use SQL Server the code works fast.