https://bugs.documentfoundation.org/show_bug.cgi?id=165928
Bug ID: 165928
Summary: MySQL/MariaDB direct Connection: Impossible to save
VARCHAR with more than 255 Characters
Product: LibreOffice
Version: 25.2.1.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Open a Base file with direct connection to MariaDB.
Create a table.
Try to create a varchar field with more than 255.
Couldn't be created.
Base would show ENUM instead of VARCHAR, if VARCHAR(1000) (or more) has been
created with PHPMyAdmin.
Note from https://mariadb.com/kb/en/varchar/:
A variable-length string. M represents the maximum column length in characters.
The range of M is 0 to 65,532. The effective maximum length of a VARCHAR is
subject to the maximum row size and the character set used. For example, utf8
characters can require up to three bytes per character, so a VARCHAR column
that uses the utf8 character set can be declared to be a maximum of 21,844
characters.
--
You are receiving this mail because:
You are the assignee for the bug.
