Subject Re: [firebird-support] Impossible to create a new database from a script
Author Dimitry Sibiryakov
17.03.2018 14:50, Mark Rotteveel mark@... [firebird-support] wrote:
> >   DEFAULT CHARACTER SET ISO8859_1
> >   COLLATION ES_ES;
> >
>
> What character set is the script file using? Is it using UTF-8 or
> WIN1252? You are currently probably connecting using NONE.
>
> If the script file is in UTF-8, add a SET NAMES UTF8;, if the script is
> WIN1252, try adding SET NAMES WIN1252; Add this **before** creating the
> database.

I would guess that script is also in ISO8859_1. SET NAMES verb can be added directly to
CREATE DATABASE statement too though this feature is not documented.

--
WBR, SD.