https://bugs.documentfoundation.org/show_bug.cgi?id=104956
Julien Nabet <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #5 from Julien Nabet <[email protected]> --- Created attachment 177244 --> https://bugs.documentfoundation.org/attachment.cgi?id=177244&action=edit test On pc Debian x86-64 with master sources updated today, I don't reproduce this. I mean, I created a brand new odb file with Firebird embedded (so had to enable experimental features). 1) select * from RDB$DATABASE shows database uses UTF8 2) SELECT relfields.RDB$RELATION_NAME, relfields.RDB$FIELD_NAME, relfields.RDB$DESCRIPTION, fields.RDB$FIELD_TYPE, fields.RDB$FIELD_SUB_TYPE, fields.RDB$FIELD_LENGTH, fields.RDB$CHARACTER_LENGTH, charset.RDB$CHARACTER_SET_NAME FROM RDB$RELATION_FIELDS relfields JOIN RDB$FIELDS fields on (fields.RDB$FIELD_NAME = relfields.RDB$FIELD_SOURCE) LEFT JOIN RDB$CHARACTER_SETS charset on (fields.RDB$CHARACTER_SET_ID = charset.RDB$CHARACTER_SET_ID) WHERE (1 = 1) AND relfields.RDB$RELATION_NAME = 'Table1' shows that number of character set is UTF8 too, character length (the number of characters) is 6 but field_length (which corresponds to the number of bytes when it's a string) is 24. I could put until 6 characters (including or not specific characters like é) and not more even if not specific characters. Indeed, trying to "abcdefg" gives: Error inserting the new record /home/julien/lo/libreoffice/connectivity/source/commontools/dbtools.cxx:745 Error code: 1 firebird_sdbc error: *arithmetic exception, numeric overflow, or string truncation *string right truncation *expected length 6, actual 7 caused by 'isc_dsql_execute' /home/julien/lo/libreoffice/connectivity/source/drivers/firebird/Util.cxx:68 Did I miss something? -- You are receiving this mail because: You are the assignee for the bug.
