[Libreoffice-bugs] [Bug 126852] MYSQL/MariaDB native connector: Column Type "TEXT" is reported as "VARCHAR"

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sat Nov 30 07:50:07 UTC 2019


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

Robert Großkopf <robert at familiegrosskopf.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |FIXED

--- Comment #6 from Robert Großkopf <robert at familiegrosskopf.de> ---
(In reply to Julien Nabet from comment #5)
> Robert: I took a look at
> https://chartio.com/resources/tutorials/understanding-strorage-sizes-for-
> mysql-text-data-types/, are you sure it should be "MEMO TEXT" and not "MEMO
> TINYTEXT" ?

The original MySQL/MariaDB datatype is TEXT. If you open the tableeditor in
Base you see Memo[TEXT]. "Memo" is only a description in Base, has nothing to
do with MySQL/MariaDB. TEXT is the type an it will have a maximum of 65525
characters.
TINYTEXT has a maximum of 255 characters.

This bug has been fixed now. The code for creating a table is misleading. Must
be 

CREATE TABLE strtest (d TEXT);

without a defined length. This will work right now with LO 6.3.4.1, fails with
LO 6.2.6.2.

I will set this one to RESOLVED FIXED

-- 
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/20191130/ee1097e6/attachment.html>


More information about the Libreoffice-bugs mailing list