breakthoven schrieb am 19.03.2011 um 01:00 (-0000):

> SQL> create domain DESCRIPTION AS VARCHAR(20) CHARACTER SET UTF8
> COLLATION UNICODE_CI_AI;
> SQL> CREATE TABLE TTTT (TEST DESCRIPTION);
> Statement failed, SQLSTATE = 22021
> unsuccessful metadata update
> -TTTT
> -COLLATION UNICODE_CI_AI for CHARACTER SET UTF8 is not installed

Using COLLATE instead of COLLATION, I succeeded:

SQL> create domain DESCRIPTION AS VARCHAR(20)
CON> character set utf8 collate unicode_ci_ai;
SQL> CREATE TABLE TTTT (TEST DESCRIPTION);
SQL> commit;

ISQL Version: WI-V2.5.0.26074 Firebird 2.5
Server version:
Firebird/x86/Windows NT (access method), version "WI-V2.5.0.26074 Firebird 2.5"
Firebird/x86/Windows NT (remote server), version "WI-V2.5.0.26074 Firebird 2.5/XNet (WLADIMIR)/P12"
Firebird/x86/Windows NT (remote interface), version "WI-V2.5.0.26074 Firebird 2.5/XNet (WLADIMIR)/P12"
on disk structure version 11.2

--
Michael Ludwig