SET SQL DIALECT 3;
SET NAMES WIN1251;
SET CLIENTLIB 'C:\Work\FirebirdBinLnk\fbclient.dll';

CREATE DATABASE 'LOCALHOST:C:\Work\ErrorDemos\IbExpert\206\Err206-1.fdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 16384
DEFAULT CHARACTER SET WIN1251;

CREATE DOMAIN "Dom1" AS SMALLINT;

CREATE DOMAIN "Dom2" AS SMALLINT;

CREATE TABLE "Table" (
    "Field1"  "Dom1" NOT NULL,
    "Field2"  "Dom2"
);

SET SQL DIALECT 3;
SET NAMES WIN1251;
SET CLIENTLIB 'C:\Work\FirebirdBinLnk\fbclient.dll';

CREATE DATABASE 'LOCALHOST:C:\Work\ErrorDemos\IbExpert\206\Err206-2.fdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 16384
DEFAULT CHARACTER SET WIN1251;

CREATE DOMAIN "Dom1" AS SMALLINT;

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

CREATE TABLE "Table" (
    "Field1"  "Dom1" NOT NULL,
    "Field2"  "Dom2" COLLATE PXW_CYRL
);

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

SET SQL DIALECT 3;

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

SET AUTODDL ON;

/******************************************************************************/
/****                           Altering domains                           ****/
/******************************************************************************/
UPDATE RDB$FIELDS
SET RDB$FIELD_TYPE = 7,
    RDB$FIELD_LENGTH = 2,
    RDB$CHARACTER_LENGTH = NULL,
    RDB$FIELD_SCALE = NULL,
    RDB$FIELD_PRECISION = NULL,
    RDB$FIELD_SUB_TYPE = NULL
WHERE RDB$FIELD_NAME = 'Dom2';

UPDATE RDB$FIELDS SET RDB$COLLATION_ID = NULL
 WHERE RDB$FIELD_NAME = 'Dom2';

COMMIT WORK;

/******************************************************************************/
/****                           Altering tables                            ****/
/******************************************************************************/
ALTER DOMAIN Dom2
  TYPE "Dom2" CHARACTER SET WIN1251;