| Subject | Re: [firebird-support] Impossible to create a new database from a script |
|---|---|
| Author | Walter R. Ojeda Valiente |
| Post date | 2018-03-17T17:29:51Z |
Hello Dimitry
The "Extract Database..." option of EMS SQL MANAGER knows that, the first lines of the script file that it generated are:
CREATE DATABASE 'localhost/3050:E:\SQL\SQL_MUAN\Databases\MUAN_MASTER_21.FDB'
USER 'SYSDBA'
PASSWORD 'masterkey'
PAGE_SIZE = 4096
DEFAULT CHARACTER SET ISO8859_1
COLLATION ES_ES;
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.
Greetings.
Walter.
On Sat, Mar 17, 2018 at 1:12 PM, Dimitry Sibiryakov sd@... [firebird-support] <firebird-support@yahoogroups.com> 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 http://www.firebirdsql.org 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 http://www.ibphoenix.com/ resources/documents/
++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++ ++++++
------------------------------ ------
Yahoo Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
firebird-support-digest@ yahoogroups.com
firebird-support-fullfeatured@ yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@ yahoogroups.com
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/ us/yahoo/utos/terms/