I set down to try creating a simple test case to send to Jason because of
us having problems with incremental searching under certain circumstances.
However, in doing so I discovered something strange.

I started off with

CREATE TABLE TEST (
ID INTEGER NOT NULL,
DESCRIPTION CHAR(10) CHARACTER SET ISO8859_1 COLLATE NO_NO,
CONSTRAINT PK_TEST PRIMARY KEY(ID));

And then I tried to insert a record with a Swedish character (since that
what was gave us problems, Swedish characters are not neccessarily included
in Norwegian collations) using a TIB_DSQL and got this error message:
"Cannot transliterate character between character sets" and no record got
inserted. This could explain our problems, but what puzzles me is that this
error message does not appear if inserting through IB_SQL (i.e. inserting
Swedish characters on a field defined with Norwegian collation is allowed
using IB_SQL, but not using a TIB_DSQL).

IB_SQL uses IBO 4.0.2C, whereas I develop using IBO 4.2Hi.

Any explanation, anyone?

Thanks,
Set