Wrong sort order advantage database 12

[jknauf]

There is a strange bug in Advantage Database Server 12.

When there is the special Character "-" in a string of a data field with an Index,
Advantage Database Server do not find the correct records. The sort order of the index "UPPER(ARTICELNO)" is wrong:

Example:
aaa-bab
aaa-bbc
aaa-bcb
aaa
abc
abd

What can I do?

Jürgen Knauf

[jknauf]

Hi Joachim,

I use as standard installation with ansi und oem collation german.

With VO I can not find the correct record.

Search:
cSuche = "aaaa"
lFound := oglServer:Seek(Upper(cSuche))

result:
lFound => true
found record => aaa-bab

It only works with oglServer:Seek(PadR(Upper(cSuche),30)).

[jhoehne]

Isn't this just this "soft seek" vs. "hard seek" thing (on failure, a "soft seek" finds the next record with a higher key)?

This is why we never use seek, but filter or ranges.

[joachim_drr]

previous ADS installations shipped a utility ansichr.exe to create your own collation sequences. It had a checkbox to 'ignore symbols' that did exact that trick.