Hallo,
ich bin Anfänger was Interbase betrifft. Jetzt habe ich das Problem, dass folgende Fehlermeldung beim Abspeichern von Daten mit Umlauten auftritt:
arithmetic exception, numeric overflow, or string trunction
Cannot transliterate character between character sets.
Laut meinem Buch "InterBase Datenbankentwicklung mit Delphi" müßte ich aber alles richtig machen. Wer kann mir helfen.
Hier noch die Metadaten der DB:
SET SQL DIALECT 3;
/* CREATE DATABASE 'D:\IBG.gdb' PAGE_SIZE 4096
DEFAULT CHARACTER SET WIN1252 */
/* Domain definitions */
CREATE DOMAIN BETRAEGE AS NUMERIC(6, 2);
CREATE DOMAIN BOOL AS CHAR(1) CHARACTER SET WIN1252
check (value in ('J','N')) NOT NULL;
CREATE DOMAIN DAT AS DATE;
CREATE DOMAIN HHSTNR AS CHAR(11) CHARACTER SET WIN1252;
CREATE DOMAIN LFDNR AS INTEGER;
CREATE DOMAIN STRING AS CHAR(50) CHARACTER SET WIN1252;
CREATE DOMAIN VSTRING AS VARCHAR(50) CHARACTER SET WIN1252;
/* Table: THHST, Owner: SYSDBA */
CREATE TABLE "THHST"
(
"HHST" "HHSTNR" NOT NULL,
"BEZEICHNUNG" "VSTRING",
"LFD" "LFDNR",
PRIMARY KEY ("HHST")
);
/* Table: TMAIN, Owner: SYSDBA */
CREATE TABLE "TMAIN"
(
"SID" "VSTRING" NOT NULL,
"HHST" "HHSTNR",
"LFD" "LFDNR",
"NAME" "STRING",
"VERWENDUNG" "STRING",
"BEMERKUNG" "STRING",
"BETRAG" "BETRAEGE",
"DATUM" "DAT",
"USERNAME" "VSTRING",
"STORNO" "BOOL",
"QERSTELLT" "BOOL",
PRIMARY KEY ("SID")
);
/* Table: TUSER, Owner: SYSDBA */
CREATE TABLE "TUSER"
(
"USERNAME" "VSTRING" NOT NULL,
"BESTAND" "BETRAEGE",
"LASTRESET" "DAT",
PRIMARY KEY ("USERNAME")
);
/* Grant Roles for this database */
/* Grant permissions for this database */
ich bin Anfänger was Interbase betrifft. Jetzt habe ich das Problem, dass folgende Fehlermeldung beim Abspeichern von Daten mit Umlauten auftritt:
arithmetic exception, numeric overflow, or string trunction
Cannot transliterate character between character sets.
Laut meinem Buch "InterBase Datenbankentwicklung mit Delphi" müßte ich aber alles richtig machen. Wer kann mir helfen.
Hier noch die Metadaten der DB:
SET SQL DIALECT 3;
/* CREATE DATABASE 'D:\IBG.gdb' PAGE_SIZE 4096
DEFAULT CHARACTER SET WIN1252 */
/* Domain definitions */
CREATE DOMAIN BETRAEGE AS NUMERIC(6, 2);
CREATE DOMAIN BOOL AS CHAR(1) CHARACTER SET WIN1252
check (value in ('J','N')) NOT NULL;
CREATE DOMAIN DAT AS DATE;
CREATE DOMAIN HHSTNR AS CHAR(11) CHARACTER SET WIN1252;
CREATE DOMAIN LFDNR AS INTEGER;
CREATE DOMAIN STRING AS CHAR(50) CHARACTER SET WIN1252;
CREATE DOMAIN VSTRING AS VARCHAR(50) CHARACTER SET WIN1252;
/* Table: THHST, Owner: SYSDBA */
CREATE TABLE "THHST"
(
"HHST" "HHSTNR" NOT NULL,
"BEZEICHNUNG" "VSTRING",
"LFD" "LFDNR",
PRIMARY KEY ("HHST")
);
/* Table: TMAIN, Owner: SYSDBA */
CREATE TABLE "TMAIN"
(
"SID" "VSTRING" NOT NULL,
"HHST" "HHSTNR",
"LFD" "LFDNR",
"NAME" "STRING",
"VERWENDUNG" "STRING",
"BEMERKUNG" "STRING",
"BETRAG" "BETRAEGE",
"DATUM" "DAT",
"USERNAME" "VSTRING",
"STORNO" "BOOL",
"QERSTELLT" "BOOL",
PRIMARY KEY ("SID")
);
/* Table: TUSER, Owner: SYSDBA */
CREATE TABLE "TUSER"
(
"USERNAME" "VSTRING" NOT NULL,
"BESTAND" "BETRAEGE",
"LASTRESET" "DAT",
PRIMARY KEY ("USERNAME")
);
/* Grant Roles for this database */
/* Grant permissions for this database */
Comment