[Libreoffice-bugs] [Bug 105711] FIREBIRD: Couldn' t create a varchar-field with less than 20 characters in GUI

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=105711

--- Comment #7 from Tamas Bunth <btomi96 at gmail.com> ---
The driver uses UTF-8 encoding for text-based columns (char, varchar, clob).
see: https://bugs.documentfoundation.org/show_bug.cgi?id=105142

A character now occupies up to 4 bytes, so when the 'length' option in the GUI
is set to 5 it will allocate 20 bytes.

You can put more than 5 characters, because most of the characters don't need
all the 4 bytes. Eg. you can put 20 characters if you use only the first 128
characters of ASCII.

SO what is the correct behavior of the 'length' GUI option set to 5?

- The user can put 20 bytes to the field. (it is the current version)

- The user can put only 5 characters even if there is more space allocated.

I think the correct one would be the second: the user can put only 5 characters
(because the first version is really annoying when using the fixed char column,
it is more straightforward and the functionality is the same as with HSQLDB).

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170527/e00eaaef/attachment.html>