Subject Re: [firebird-support] Firebird 3.0 Column name length
Author Mark Rotteveel
On 09/12/2019 09:05, Nikolay Marinov kok_bg@... [firebird-support]
wrote:
> using WIN1251 , this query works fine in FB 2.5
>
> 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.

This is probably related to [CORE-2350][1], see also Firebird 3 release
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