Have Debian 9 and Debian 10 Linux.
Debian 9 have LO Base 5.272
Debian 10 have LO Base 6.1.52
Connected same way to mysql database. . LO 5 showing everything ok, but LO 6 cutting ends of table data and showing incorrectly data.
So where is difference? Nothing changed. both are same *.odb files on different pcs, but mysql database is same on another pc.
first image from LO Base 5
Second image LO Base 6
First idea: you created the database using some iso-8859-* encoding (LO5) and now are using utf-8 to create the LO6 view.
no, they both have UTF-8
Hello,
The one item which may be a problem is the connector you are using. If using the native connector, this changed from a MySQL connector to a MariaDB connector somewhere early in the 6.x releases. As it caused different problems for my personal DB’s (had to do with macro processing) I abandoned MySQL.
Appears the major problem may involve a specific field type. If you are using the native connector, try using a JDBC connector.
Need to dig deeper because i tried on Gentoo LO 6.4 and works perfectly with native connector.
P.S. mysql server is mysql NOT maria. Its on another server. I start thinking it Debian packages somewhere corrupted.