[Libreoffice-bugs] [Bug 105711] FIREBIRD: Couldn't create a varchar-field with less than 20 characters in GUI
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Fri Nov 8 14:53:47 UTC 2019
https://bugs.documentfoundation.org/show_bug.cgi?id=105711
--- Comment #18 from Robert Großkopf <robert at familiegrosskopf.de> ---
(In reply to Lionel Elie Mamane from comment #17)
> IIRC, this was done to handle the "worst case scenario" of a Unicode
> character needing 4 bytes in storage, and since in Firebird the length of a
> varchar field is bytes and not characters... to be sure to put 1, resp. 5,
> characters we must allocate a VARCHAR(4), respectively a VARCHAR(20).
It's funny. I tested this with the second attachement. The database had been
created with LO 5.4. You couldn't add more than '12345' to a
5-characters-field. A message appears, that there couldn't be added more than 5
characters. Try it.
After reading comment 16 I tested it with a database I created new. And soon
the described behaviour appears. It isn't the same bug which appears first, but
the behaviour of the database created with LO 5.4 is better than the behaviour
of the database created now.
Has the internal database been changed since LO 5.4.0.0.beta1?
--
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/20191108/9d366e0b/attachment-0001.html>
More information about the Libreoffice-bugs
mailing list