I am using Delphi 10.3.2, UniDAC 8.0.1, FirebirdSQL 2.5.9.27139, targeting Win32 platform.
My database have SpecificOption Codepage = WIN1254
1) I have a table created as below:
Code: Select all
CREATE TABLE DOCUMENTFILE (
DOCUMENTFILEID INTEGER NOT NULL PRIMARY KEY,
DOCUMENTFILEDOC BLOB SUB_TYPE BINARY SEGMENT SIZE 20,
DOCUMENTFILEDOCTYPE VARCHAR(5),
DOCUMENTFILEDOCNAME VARCHAR(100),
NOTE VARCHAR(100)
);
When I take a backup, generated file cannot be restored. First exception says:
Code: Select all
Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 38.
Code: Select all
Parser: The unknown symbol $000B ''
2) Moreover, I have another table created as following:
Code: Select all
CREATE DOMAIN "BOOLEAN" AS
SMALLINT
CHECK (value is null or value in (0,1));
CREATE TABLE EINVOICEIN (
UUID VARCHAR(38) NOT NULL PRIMARY KEY,
ID VARCHAR(20),
DOCUMENTID INTEGER,
SENDER VARCHAR(100),
RECEIVER VARCHAR(100),
SUPPLIER VARCHAR(100),
CUSTOMER VARCHAR(100),
ISSUEDATE DATE,
CREATEDATETIME TIMESTAMP,
CURRENCY VARCHAR(5),
AMOUNT NUMERIC(18,4),
INVOICETYPECODE VARCHAR(5),
STATUS VARCHAR(20),
STATUSDESCRIPTION VARCHAR(100),
GIBSTATUSCODE SMALLINT,
GIBSTATUSDESCRIPTION VARCHAR(100),
RESPONSECODE VARCHAR(20) CHARACTER SET NONE,
RESPONSEDESCRIPTION VARCHAR(100),
CONTENT BLOB SUB_TYPE TEXT SEGMENT SIZE 4096,
LOCKED SMALLINT DEFAULT 0,
INOUT "BOOLEAN",
REPLYTOINVOICE "BOOLEAN",
REJECTEDINVOICE "BOOLEAN",
ROOTINVOICE "BOOLEAN",
COMMERCIALINVOICE "BOOLEAN",
RETURNEDINVOICE "BOOLEAN"
);
Code: Select all
Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 91, column 296.
Script:
Code: Select all
-- UniDAC version: 8.0.1
-- InterBase server version: 2.5.9.27139
-- InterBase client version: 2.5
-- Script date 27.08.2019 17:40:32
DELETE FROM ACCOUNTINGFORMTYPE;
INSERT INTO ACCOUNTINGFORMTYPE VALUES (10, 'Satış');
INSERT INTO ACCOUNTINGFORMTYPE VALUES (20, 'Alış');
INSERT INTO ACCOUNTINGFORMTYPE VALUES (30, 'Ödeme');
INSERT INTO ACCOUNTINGFORMTYPE VALUES (40, 'Tahsilat');
Code: Select all
UniDump1.RestoreFromFile('20190827_174032.bak');
Code: Select all
CREATE TABLE ACCOUNTINGFORMTYPE (
ACCOUNTINGFORMTYPEID INTEGER NOT NULL,
ACCOUNTINGFORMTYPENAME VARCHAR(100)
);
I have deleted first record in above script "10, Satış" from table and it is not coming back after executing restore at above line.
Any help is appreciated.