SET SQL DIALECT 3;
SET NAMES UTF8;
CREATE DATABASE 'col.fdb' USER 'SYSDBA' PASSWORD 'masterkey' PAGE_SIZE 16384 DEFAULT CHARACTER SET UTF8 COLLATION UTF8;
CREATE COLLATION NUMBERSORT FOR UTF8 FROM UNICODE PAD SPACE CASE INSENSITIVE ACCENT SENSITIVE 'NUMERIC-SORT=1';
CREATE DOMAIN D_VC AS VARCHAR(10);
CREATE TABLE TBL (FLD  D_VC );

SET SQL DIALECT 3;
SET NAMES UTF8;
CREATE DATABASE 'wcol.fdb' USER 'SYSDBA' PASSWORD 'masterkey' PAGE_SIZE 16384 DEFAULT CHARACTER SET UTF8 COLLATION UTF8;
CREATE DOMAIN D_VC AS VARCHAR(10);
CREATE TABLE TBL (FLD  D_VC );

SET SQL DIALECT 3;
SET NAMES UTF8;
CREATE DATABASE 'col.fdb' USER 'SYSDBA' PASSWORD 'masterkey' PAGE_SIZE 16384 DEFAULT CHARACTER SET UTF8 COLLATION UTF8;
CREATE COLLATION NUMBERSORT FOR UTF8 FROM UNICODE PAD SPACE CASE INSENSITIVE ACCENT SENSITIVE 'NUMERIC-SORT=1';
CREATE DOMAIN D_VC AS VARCHAR(10);
CREATE DOMAIN D_VC_NS AS VARCHAR(10) CHARACTER SET UTF8 COLLATE NUMBERSORT;
CREATE TABLE TBL (FLD  D_VC_NS);

SET NAMES UTF8;
SET SQL DIALECT 3;
CONNECT 'wcol.fdb' USER 'SYSDBA' PASSWORD 'masterkey';
SET AUTODDL ON;
CREATE DOMAIN D_VC_NS AS VARCHAR(10) CHARACTER SET UTF8 COLLATE NUMBERSORT;
ALTER TABLE TBL ALTER COLUMN FLD TYPE D_VC_NS;