<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED WORKSFORME - FIREBIRD: Couldn't create a varchar-field with less than 20 characters in GUI" href="https://bugs.documentfoundation.org/show_bug.cgi?id=105711#c17">Comment # 17</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED WORKSFORME - 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>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).</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>