[jdbc] [mysql] Using current MySQL database as persistence leads to error in String Item-creation about openhab-addons HOT 3 CLOSED

Related type defined here:

And character set used in relation to this issue is utf8mb4 (see #16635 (comment))

For that character set, VARCHAR is limited to 16383 - see https://dev.mysql.com/doc/refman/8.3/en/storage-requirements.html:

The effective maximum number of bytes that can be stored in a VARCHAR or VARBINARY column is subject to the maximum row size of 65,535 bytes, which is shared among all columns. For a VARCHAR column that stores multibyte characters, the effective maximum number of characters is less. For example, utf8mb4 characters can require up to four bytes per character, so a VARCHAR column that uses the utf8mb4 character set can be declared to be a maximum of 16,383 characters. See Section 10.4.7, “Limits on Table Column Count and Row Size”.

from openhab-addons.

See also #13920.

from openhab-addons.

@binderth - as a work-around you can configure the size here:

Or in services/jdbc.config:

sqltype.STRING        =   VARCHAR(16255)

I have provided a PR for fixing the default size for MySQL.

from openhab-addons.