Subject Re: Wrong output script generate by isql.
Author hamacker
But the same problem.


2013/7/2 hamacker <sirhamacker@...>

> Sorry, I copy and paste wrong cmd.
> 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.
>>
>
>


[Non-text portions of this message have been removed]