Hello all,

when creating a database and tables, I have problems when specifying ISO8859_1 as the desired charset. I'm working with Firebird-1.5.2.4719-0_RC3_embed_win32 / ADO.NET provider:

CREATE DOMAIN EntityInfo AS VARCHAR(160) CHARACTER SET ISO8859_1;

as soon as I try to create a table including this domain definition, I get an error:

CREATE TABLE Albums (
-- Albums title/name
Title EntityInfo NOT NULL
);

Type: FirebirdSql.Data.Firebird.FbException: unsuccessful metadata update
ALBUMS

at FirebirdSql.Data.Firebird.FbCommand.CommitImplicitTransaction()
at FirebirdSql.Data.Firebird.FbCommand.ExecuteNonQuery()
at MediaBox.Test.ParseSQLFile(String FileName)
at MediaBox.Test.Create()
at MediaBox.Test.Main(String[] args)
ErrorCode: 335544351
Errors[0]:
Errors[0].Class: 0
Errors[0].LineNumber: 0
Errors[0].Message: unsuccessful metadata update
Errors[0].Number: 335544351
Errors[1]:
Errors[1].Class: 0
Errors[1].LineNumber: 0
Errors[1].Message: ALBUMS
Errors[1].Number: 335544382
Errors[2]:
Errors[2].Class: 0
Errors[2].LineNumber: 0
Errors[2].Message:
Errors[2].Number: 0
Message: unsuccessful metadata update
ALBUMS

Database is created with no specified default charset. When creating the domain with CHARACTER SET ASCII, the table creation runs fine, the same thing when omitting the CHARACTER SET.

Is ISO8859_1 not fully supported? I can query this charset with

SELECT RDB$CHARACTER_SET_NAME, RDB$CHARACTER_SET_ID
FROM RDB$CHARACTER_SETS
ORDER BY RDB$CHARACTER_SET_NAME;

What am I doing wrong?

Kind regards
Alexander Gräf