Base 4.2.1 & MySQL text entry length update

Discuss the database features
Post Reply
Spaltersar
Posts: 2
Joined: Wed Mar 13, 2019 5:13 pm

Base 4.2.1 & MySQL text entry length update

Post by Spaltersar »

I have following Problem:

Im using OO Base Forms to generate and edit Datasets in a Database connected via direct connection mysql.

When im trying to edit/update an existing Dataset, i only can use the number of chars i already used in the existing entry.

Example:

in table there is a data field called "name". type of field is to varchar, length is set to 4096.

If I add data like "smith" there and then save Dataset, i only can use max. 5 chars of length, when i try to edit/update it.

How can i stop this behavior?

phpmyadmin does the job w/o any problems.

Thank You.

Spaltersar
Last edited by Spaltersar on Thu Mar 14, 2019 3:02 pm, edited 1 time in total.
OpenOffice 4.1.6 on Windows 7 x86
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Base 4.2.1 & MySQL text entry length update

Post by Villeroy »

Should not happen and it is not a known issue. Are you connecting via ODBC or JDBC? Have you tried the other way? I recommend LibreOffice because LibreOffice is under active development.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Spaltersar
Posts: 2
Joined: Wed Mar 13, 2019 5:13 pm

Re: Base 4.2.1 & MySQL text entry length update

Post by Spaltersar »

I'm using this driver extension:

https://extensions.openoffice.org/en/pr ... fice-120-3

built in solution didn't worked for me.

greetings

Spaltersar
OpenOffice 4.1.6 on Windows 7 x86
Post Reply