Subject | Re: [firebird-support] Impossible to create a new database from a script |
---|---|
Author | Mark Rotteveel |
Post date | 2018-03-17T17:42:27Z |
On 17-3-2018 18:07, 'Walter R. Ojeda Valiente'
sistemas2000profesional@... [firebird-support] wrote:
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
sistemas2000profesional@... [firebird-support] wrote:
> Sorry, but I don't understand. The script file is a plain text file. I'plain' text files are just bytes that only get meaning in the encoding
> had never used UTF8, I always use ISO8859_1
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