Error message "expected length N, actual M" contains wrong value of M when charset UTF8 is used in the field declaration of a table -----------------------------------------------------------------------------------------------------------------------------------
Key: CORE-6414 URL: http://tracker.firebirdsql.org/browse/CORE-6414 Project: Firebird Core Issue Type: Bug Components: Charsets/Collation, Engine Affects Versions: 3.0.6, 4.0 Beta 2 Reporter: Pavel Zotov recreate table test(nm varchar(1) character set win1251 default 'QWERTYUIOP' not null); Statement failed, SQLSTATE = 22001 arithmetic exception, numeric overflow, or string truncation -string right truncation -expected length 1, actual 10 /* 10 is OK, this is number of characters in the default string */ recreate table test(nm varchar(1) character set utf8 default 'QWERTYUIOP' not null); Statement failed, SQLSTATE = 22001 arithmetic exception, numeric overflow, or string truncation -string right truncation -expected length 1, actual 4 /* value 4 is wrong and is issued regardless of default string length */ Checked on: WI-V3.0.7.33372; WI-V4.0.0.2225 (ticket is created after discussion with Adriano; perhaps similar problem already was described in some another ticket) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel