Subject Re: [firebird-support] Impossible to create a new database from a script
Author Mark Rotteveel
On 17-3-2018 18:07, 'Walter R. Ojeda Valiente'
sistemas2000profesional@... [firebird-support] wrote:
> Sorry, but I don't understand. The script file is a plain text file. I
> had never used UTF8, I always use ISO8859_1

'plain' text files are just bytes that only get meaning in the encoding
used to save it. If the tool you used to author the script used utf-8 as
the encoding, then ยบ is stored in a different combination of bytes then
when encoding ISO-8859-1 had been used.

Even more, internally the metadata tables of Firebird (including
comments) use UTF8 (or UNICODE_FSS) as the character set, so if you use
connection character set NONE, while sending ISO-8859-1 bytes, that can
result in transliteration errors as some combinations of bytes are
simply illegal when trying to store in a UTF8 column.

Mark

--
Mark Rotteveel