Subject | Re: [firebird-support] Firebird 3.0 Column name length |
---|---|
Author | Mark Rotteveel |
Post date | 2019-12-09T18:01:56Z |
On 09/12/2019 09:05, Nikolay Marinov kok_bg@... [firebird-support]
wrote:
notes, section "Enforcement of Length Limit for Local Alias and Variable
Names".
I guess the problem is that column names internally in Firebird are
UNICODE_FSS, and those 31 Cyrillic characters are more than 31 bytes in
UNICODE_FSS.
Mark
[1]: http://tracker.firebirdsql.org/browse/CORE-2350
--
Mark Rotteveel
wrote:
> using WIN1251 , this query works fine in FB 2.5This is probably related to [CORE-2350][1], see also Firebird 3 release
>
> select '123' as "Това е едно дълго име на колона" from rdb$database;
>
> under FB 3.0 it doesn't:
> can't format message 13:198 -- message file
> C:\Windows\SYSTEM32\firebird.msg not found.
> arithmetic exception, numeric overflow, or string truncation.
> string right truncation.
> expected length 31, actual 31.
notes, section "Enforcement of Length Limit for Local Alias and Variable
Names".
I guess the problem is that column names internally in Firebird are
UNICODE_FSS, and those 31 Cyrillic characters are more than 31 bytes in
UNICODE_FSS.
Mark
[1]: http://tracker.firebirdsql.org/browse/CORE-2350
--
Mark Rotteveel