Subject | Wrong output script generate by isql. |
---|---|
Author | hamacker |
Post date | 2013-07-02T18:38:48Z |
Hi All,
When I execute :
isql.exe "localhost:F:\SESMT\dados\SESMT.fdb" -U "SYSDBA" -P "masterkey"
-now -i "c:\temp\sesmt.sql" -o "c:\temp\firebird-isql.log"
I extract db metadata, but in this script appear some errors like :
(...)
OPCIONAL CHAR(1) CHARACTER SETISO8859_1 ,
STATUS CHAR(1) CHARACTER SETISO8859_1 )
(...)
Any char/varchar declaration inside procedures will be transformed to
include "CHARACTER SETISO8859_1", I think that was missed space between SET
and ISO8859_1. If I changed to domain, like :
create domain d_opcional char(1)
and use d_opcional instead char(1) then no error appears, script is
generate correctly.
I would like to know if a bug of isql.exe or I missed something in source
database.
I tested in fb2.5.2.
[Non-text portions of this message have been removed]
When I execute :
isql.exe "localhost:F:\SESMT\dados\SESMT.fdb" -U "SYSDBA" -P "masterkey"
-now -i "c:\temp\sesmt.sql" -o "c:\temp\firebird-isql.log"
I extract db metadata, but in this script appear some errors like :
(...)
OPCIONAL CHAR(1) CHARACTER SETISO8859_1 ,
STATUS CHAR(1) CHARACTER SETISO8859_1 )
(...)
Any char/varchar declaration inside procedures will be transformed to
include "CHARACTER SETISO8859_1", I think that was missed space between SET
and ISO8859_1. If I changed to domain, like :
create domain d_opcional char(1)
and use d_opcional instead char(1) then no error appears, script is
generate correctly.
I would like to know if a bug of isql.exe or I missed something in source
database.
I tested in fb2.5.2.
[Non-text portions of this message have been removed]