When updating my system application, a command line is called to execute a script to update the database. The script calls the Isql tool of Firebird by sending the file containing the SQL statements as a parameter. What happens is that there are accented words in this file and since Isql is a Console Application, the accents are not being sent as they should and Isql is returning a deformed string error.
The command line called by the application is as follows:
isql.exe "localhost:C:\Sistema\Banco\DADOS.FDB" -u SYSDBA -p masterkey -i SCRIPTSQL.txt
Following is an example running directly on the Command Prompt :
Ihavealreadytriedwiththe"Code Page" in Console: 1250, 1252, 860, etc. But still the error remains. The interesting thing is that when doing "selects" the result is accentuated correctly, but in this case to send the accented string is that the error is occurring. Is there any other "Page Code" to be used in the Command Prompt so that the accent is correctly identified?