Hello,

I've installed FB 2.1.3 and created a UTF8 based database with the following UTF8 using table:

SET SQL DIALECT 3;

CREATE TABLE FDB_CATEGORIES (
CATEGORYKEY FDB_FOODCATEGORYKEY NOT NULL
/* FDB_FOODCATEGORYKEY = INTEGER NOT NULL */,
CATEGORYNAME FDB_FOODCATEGORY
/* FDB_FOODCATEGORY = VARCHAR(240) */,
PARENTCATEGORYKEY FDB_FOODCATEGORYKEY NOT NULL
/* FDB_FOODCATEGORYKEY = INTEGER NOT NULL */
);

ALTER TABLE FDB_CATEGORIES ADD CONSTRAINT PK_FDB_CATEGORIES PRIMARY KEY (CATEGORYKEY);

The domain of the CATEGORYNAME is defined as follows, the others are simply integer with not null set:

CREATE DOMAIN FDB_FOODCATEGORY AS
VARCHAR(240) CHARACTER SET UTF8
COLLATE UTF8;

When I try to insert a row with a categoryname which has german umlauts it doesn't work. Neither from ibExpert nor from ISQL:

SQL> set names UTF8;
SQL> insert into fdb_categories(categorykey, categoryname, parentcategorykey) va
lues(2, 'Gemüse', 1);
Statement failed, SQLCODE = -104
Malformed string
SQL>

Insertion of 'Gemuese' works though, so it seems to be a charset related problem.

What is wrong here? The OS used is a German Windows XP professional in a standard German setup. Any help appreciated.