Hi,

I have a problem with incremental search in an ib_grid.

The ordering is on a column with following description:

VARCHAR (15) CHARACTER SET ISO8859_1
COLLATE DE_DE

First of all, there is a strange ordering.
For example it is ordered as following:

STAXXXX
STEXXXX
ST.UXXXX
STYXXXX

Normaly, the ST.UXXXX has to be ordered first, because "." is less
than "A".
When I start incremental search on this data with "ST." it jumps
to "STAXXXX" instead of "ST.UXXXX".

Another example:

STAXXXX
STEXXXX
ST-UXXXX
STYXXXX

Here the ordering is as wrong as in the first example, but the
incsearch leads to another strange result.
When I start incremental search on this data with "ST-" it also jumps
to "STAXXXX" instead of "ST-UXXXX", but when I continue inserting
an "U", it jumps to "ST-UXXX". In the first example with the "." this
doesn't work.

What is the reason for this problem and how could I solve this?

Kind regards
Helmut