<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - FIREBIRD: Couldn't create a varchar-field with less than 20 characters in GUI" href="https://bugs.documentfoundation.org/show_bug.cgi?id=105711#c11">Comment # 11</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - FIREBIRD: Couldn't create a varchar-field with less than 20 characters in GUI" href="https://bugs.documentfoundation.org/show_bug.cgi?id=105711">bug 105711</a> from <a class="email" href="mailto:lionel@mamane.lu" title="Lionel Elie Mamane <lionel@mamane.lu>"> Lionel Elie Mamane</a> <pre>(In reply to Tamas Bunth from <a href="show_bug.cgi?id=105711#c10">comment #10</a>) > (In reply to Lionel Elie Mamane from <a href="show_bug.cgi?id=105711#c9">comment #9</a>) >> 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>