Subject Re: [firebird-support] Impossible to create a new database from a script
Author Walter R. Ojeda Valiente
Hello Dimitry

As I said before, I always use ISO8859_1. Always, no exception to this rule.

The "Extract Database..." option of EMS SQL MANAGER knows that, the first lines of the script file that it generated are:

  PASSWORD 'masterkey'
  PAGE_SIZE = 4096

As you can see, the lines are right, the character set is ok; but when I tried to execute that script file the before mentioned error happened. The solution was to write SET NAMES ISO8859_1; before the CREATE DATABASE statement and execute the script file with ISQL, no with EMS SQL MANAGER, because it always stop in the lines with comments. But with the INPUT command of ISQL.EXE it works fine.

Anyway, the problem is solved.



Libre de virus.

On Sat, Mar 17, 2018 at 1:12 PM, Dimitry Sibiryakov sd@... [firebird-support] <> wrote:
17.03.2018 18:07, 'Walter R. Ojeda Valiente' sistemas2000profesional@gmail. com
[firebird-support] wrote:
> Sorry, but I don't understand. The script file is a plain text file.

   Exactly because if that it has a definite encoding. And you, as its author, must know
what encoding you used when press "Save" button in editor. And you must inform Firebird
which encoding it is. You must do all this right otherwise you'll get the error which you
actually got.

   WBR, SD.

------------------------------ ------

------------------------------ ------

++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++ ++++++

Visit and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at resources/documents/

++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++ ++++++
------------------------------ ------

Yahoo Groups Links

<*> To visit your group on the web, go to: firebird-support/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to: firebird-support/join
    (Yahoo! ID required)

<*> To change settings via email:

<*> To unsubscribe from this group, send an email to:

<*> Your use of Yahoo Groups is subject to: us/yahoo/utos/terms/