SET SQL DIALECT 3;
SET NAMES WIN1251;
SET CLIENTLIB 'C:\Work\Firebird25BinLnk\fbclient.dll';
CREATE DATABASE 'LOCALHOST:C:\Work\ErrorDemos\IbExpert\215\Err215-1.fdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 16384
DEFAULT CHARACTER SET WIN1251 COLLATION PXW_CYRL;

CREATE DOMAIN "DomTest" AS
VARCHAR(10) CHARACTER SET WIN1251
COLLATE PXW_CYRL;

CREATE TABLE "Table1" (
    "Test"  "DomTest" COLLATE PXW_CYRL );

CREATE TABLE "Table1" (
    "Test"  "DomTest" COLLATE WIN1251 );

/* Server version: WI-V6.3.8.27089 Firebird 2.5 
   SQLDialect: 3. ODS: 11.2. Forced writes: On. Sweep interval: 20000.
   Page size: 16384. Cache pages: 2048 (32768 Kb). Read-only: False. */
SET CLIENTLIB 'C:\Work\Firebird25BinLnk\fbclient.dll';
SET NAMES WIN1251;

SET SQL DIALECT 3;

CONNECT 'LOCALHOST:C:\Work\ErrorDemos\IbExpert\215\Err215-2.fdb' USER 'SYSDBA' PASSWORD 'masterkey';

SET AUTODDL ON;

/******************************************************************************/
/****                           Altering tables                            ****/
/******************************************************************************/
UPDATE RDB$RELATION_FIELDS
SET RDB$COLLATION_ID = 0
WHERE (RDB$RELATION_NAME = 'Table1') AND (RDB$FIELD_NAME = 'Test');

COMMIT WORK;

CREATE TABLE "Table1" (
    "Test"  "DomTest" COLLATE PXW_CYRL
);