Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Sort change
Thu, Jul 15 2010 5:57 AMPermanent Link

Jose Eduardo Helminsky

HPro Informatica

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

Thu, Jul 15 2010 6:38 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

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
Fri, Jul 16 2010 5:41 AMPermanent Link

Jose Eduardo Helminsky

HPro Informatica

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

Image