Accent code page in Command Prompt

Asked

Viewed 197 times

0

When updating my system application, a command line is called to execute a script to update the database. The script calls the tool Isql of Firebird sending as parameter the file that contains the SQL statements. What happens is that there are accented words in this file and as Isql is a Console Application, the accents are not being sent as it 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

Here is an example running directly on Command Prompt: inserir a descrição da imagem aqui

I have tried with the "Page Codes (Code Page)" in the Console: 1250, 1252, 860, etc. But still the error remains. The interesting thing is that when performing "selects" the result is marked 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?

firebird cmd console accentuation

  • What is the accentuation? ´?

  • Any word that has accents: Code, No, Sugar, etc.

1 answer

0

Try using the code page 65001:

chcp 65001

  • did not work, this code must insert some invalid character together, or even "commit" in the database, the Isql tool is terminated immediately if the word used has accents.

Browser other questions tagged firebird cmd console accentuation

You are not signed in. Login or sign up in order to post.