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

Robert Großkopf <[email protected]> changed:

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

--- Comment #6 from Robert Großkopf <[email protected]> ---
(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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to