Hi everybody,

I'm using IBO 4.2E core components in one of my projects. The
database is located either on a linux machine and on a W2k machine.

This is a part of the DDL of the "problem-table"

CREATE TABLE DSS_VP (
...
NAME VARCHAR(60) CHARACTER SET NONE,
VORNAME VARCHAR(40) CHARACTER SET NONE,
ANREDE VARCHAR(20) CHARACTER SET NONE,
...

);

I ve added datasets which have in Field NAME names with German
special characters. They were proper shown and handled but...

I cannot search them with

SELECT * from DSS_VP where NAME like 'Händel%'

by using software (my project) and IBEXPERT e.g. which is, a I might
have read somewhere, also created by using IBO.

If I'm going to use the IBConsole with the same SQL, it works.

Changing the character set to ASCII or WIN1250 doesn't help.
My project and IBEXPERT them come up both with an error "Cannot
translate between charactersets".

I would appreciate any help.

Regards

Thomas