https://bugs.documentfoundation.org/show_bug.cgi?id=147893
--- Comment #5 from Robert Großkopf <[email protected]> --- CHAR_LENGTH() will give the expected value for type CHAR. It will be the same value as defined in the table. But the field will be filled with spaces like it would have if using "normal ASCII". So a field defined for length 3 has 3 defined characters and 9 spaces. There will appear an error if I try to input 4 characters in such a field: firebird_sdbc error: *Dynamic SQL Error *SQL error code = -303 *arithmetic exception, numeric overflow, or string truncation *string right truncation *expected length 3, actual 12 So it counts the right length together with the spaces. But if I delete the just added (4.) character it will save the content. -- You are receiving this mail because: You are the assignee for the bug.
