Subject | Re: Wrong output script generate by isql. |
---|---|
Author | hamacker |
Post date | 2013-07-02T19:01:11Z |
But the same problem.
2013/7/2 hamacker <sirhamacker@...>
2013/7/2 hamacker <sirhamacker@...>
> Sorry, I copy and paste wrong cmd.[Non-text portions of this message have been removed]
> Correct is :
> isql.exe" 'C:\SESMT\DADOS\SESMT.FDB' -U "SYSDBA" -P "masterkey" -x -now -o
> "c:\temp\sesmt.sql"
>
>
> 2013/7/2 hamacker <sirhamacker@...>
>
>> 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.
>>
>
>