On Sat, Mar 17, 2018 at 10:22 AM, Dimitry Sibiryakov sd@... [firebird-support] <firebird-support@yahoogroups.com> wrote:

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.


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

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

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

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/