[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 #11 from Lionel Elie Mamane <lionel at mamane.lu> ---
(In reply to Tamas Bunth from comment #10)
> (In reply to Lionel Elie Mamane from comment #9)

>> I'd just let it be, and let the Firebird "misfeature" bubble up. A length of
>> 5 in the GUI should be a VARCHAR(5) in Firebird. If firebird understands
>> that as 5 bytes, then so be it.

> A length of 5 in the GUI is a VARCHAR(5) in Firebird, which allocates 20
> bytes (as long as the character set is UTF-8).

> The problem is rather the following:
> Firebird truncates the input string at 20 bytes no matter how many
> characters it contains.

> I think it's a bug in Firebird (but I couldn't find it in the bug tracker).

> There are two kind of length functions (actually there are three of them):
> char_length and octet_length[1]

> and they are working as expected.

So Firebird already has a working notion & implementation of "character". So
definitely, yes, I'd say that the right place to fix that is Firebird. Just
file it as a bug.

-- 
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/20170528/b693aa23/attachment-0001.html>