hi
i have database creation script containing the declaration of a
custom collation which is supposed to be used later when creating some
domains..that doesnt work as it should..does anyone know why? this is
an excerpt:

/* start of script */

SET SQL DIALECT 3;

SET NAMES UNICODE_FSS;

CREATE DATABASE 'C:\Dokumente und Einstellungen\Sancho\Eigene
Dateien\empty.FDB'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 16384
DEFAULT CHARACTER SET UNICODE_FSS;


INSERT INTO rdb$collations (
rdb$collation_name,
rdb$collation_id,
rdb$character_set_id
)
VALUES
(
'CUSTOM_COLLATION1',
250,
(SELECT RDB$CHARACTER_SET_ID FROM RDB$CHARACTER_SETS WHERE
RDB$CHARACTER_SET_NAME = 'UNICODE_FSS')
);

/* now i want to use my new collation */

CREATE DOMAIN CHAR_1 AS
VARCHAR(1) COLLATE CUSTOM_COLLATION1; /* here i get: "unknown
collation" */

/* and so on */

/* end of script */



thanx,

martin