Some of my customers complains about change of sort.

DBISAM 4.29 Build 3
Table language = Brazilian Portuguese

Field DES Character 40
Index DES (case insensitive)
I have already checked that index is not descending.

It shows me:

MACHO MANUAL HSS-MF
MACHO MANUAL HSS BSP

In my opinion the correct order should be the opposite

MACHO MANUAL HSS BSP
MACHO MANUAL HSS-MF

Eduardo

Eduardo,

<< Some of my customers complains about change of sort. >>

There have been no changes to the index sorting/comparisons in DBISAM for
several years.  In fact, I don't think they've changed since DBISAM 3.x.

<< It shows me:

MACHO MANUAL HSS-MF
MACHO MANUAL HSS BSP

In my opinion the correct order should be the opposite

MACHO MANUAL HSS BSP
MACHO MANUAL HSS-MF >>

DBISAM has always used a "string sort", meaning that it treats the hyphen
and apostrophe like any other symbol and sort them *before* any alphanumeric
symbols.   Look in the Win32 help that comes with Delphi under CompareString
for the SORT_STRINGSORT flag notes.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

> DBISAM has always used a "string sort", meaning that it treats the hyphen
> and apostrophe like any other symbol and sort them *before* any
> alphanumeric symbols.   Look in the Win32 help that comes with Delphi
> under CompareString for the SORT_STRINGSORT flag notes.
I will see this. Thanks for the information

Eduardo