[Firebird] Create Table schlägt fehl wegen UTF8?

[Jürgen Thomas]

Ich hoffe, es hilft:

SQL-Code:

SET SQL DIALECT 3;
SET NAMES UTF8;

CREATE DATABASE 'F:\VS_NET\Daten\Systemdaten\VS-Adressen.FDB'
USER 'XXX' PASSWORD 'YYY'
PAGE_SIZE 16384
DEFAULT CHARACTER SET UTF8;

/*                           User Defined Functions                           */
DECLARE EXTERNAL FUNCTION ABS
    DOUBLE PRECISION
    RETURNS DOUBLE PRECISION BY VALUE
    ENTRY_POINT 'IB_UDF_abs' MODULE_NAME 'ib_udf';
/*  usw. 37 Standardfunktionen  */

/*                                  Domains                                   */
/*  beschränkt auf die für CreateTable vorgesehenen  */
CREATE DOMAIN DNTEXT50 AS VARCHAR(50);
CREATE DOMAIN DVUSER AS VARCHAR(35) DEFAULT USER NOT NULL;
CREATE DOMAIN D_CHAR AS CHAR(1) DEFAULT '' NOT NULL;
CREATE DOMAIN D_CURR AS DECIMAL(18,2) DEFAULT 0 NOT NULL;
CREATE DOMAIN D_CURRENCY AS CHAR(3) DEFAULT 'EUR' NOT NULL;
CREATE DOMAIN D_DATE AS DATE DEFAULT 'NOW' NOT NULL;
CREATE DOMAIN D_DATETIME AS TIMESTAMP DEFAULT 'NOW' NOT NULL;
CREATE DOMAIN D_I255 AS INTEGER DEFAULT 0 NOT NULL
   CHECK (VALUE BETWEEN 0 AND 255);
CREATE DOMAIN D_ID AS INTEGER DEFAULT 0 NOT NULL;
CREATE DOMAIN D_JJ AS SMALLINT DEFAULT 0 NOT NULL 
   CHECK (VALUE BETWEEN 100 AND 9999);

/*                                 Generators                                 */
CREATE GENERATOR ACCOUNT_ID;
CREATE GENERATOR A_ENTRY_ID;
/*  usw. insgesamt 31 Generatoren  */

Der nächste Schritt sollten die Tables sein, beginnend mit der im ersten Beitrag genannten.

Jürgen