firebird icon indicating copy to clipboard operation
firebird copied to clipboard

FB3 and possibly others - isql.exe - metadata export - ALTER CHARACTER SET stands befor CREATE COLLATION

Open RusMikle opened this issue 3 years ago • 0 comments

As a result, a situation arises when we use the COLLATION before it was created. Example:

"C:\Program Files\Firebird\Firebird3\isql.exe" -x -output ExampleDb.sql D:\Db\ExampleDb.FDB

ExampleDb.sql:

SET SQL DIALECT 3; 

CREATE DATABASE 'D:\Db\ExampleDb.FDB' PAGE_SIZE 16384 DEFAULT CHARACTER SET ISO8859_1;

/*  Character sets */
ALTER CHARACTER SET ISO8859_1 SET DEFAULT COLLATION BPS;

/*  Collations */
CREATE COLLATION BPS FOR ISO8859_1 FROM EXTERNAL ('DE_DE') PAD SPACE CASE INSENSITIVE 'SPECIALS-FIRST=1';

As a result, by execute, we have an error: "C:\Program Files\Firebird\Firebird3\isql.exe" -i D:\Db\ExampleDb.sql ..... -ALTER CHARACTER SET ISO8859_1 failed -COLLATION BPS for CHARACTER SET ISO8859_1 is not defined After line 4 in file ExampleDb.sql

Exist in Firebird 3. Perhaps the bug exists in other versions too.

RusMikle avatar Sep 23 '22 07:09 RusMikle