Base 4.2.1 & MySQL text entry length update

Discuss the database features

Base 4.2.1 & MySQL text entry length update

Postby Spaltersar » Wed Mar 13, 2019 5:31 pm

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
Spaltersar
 
Posts: 2
Joined: Wed Mar 13, 2019 5:13 pm

Re: Base 4.2.1 & MySQL text entry length update

Postby Villeroy » Wed Mar 13, 2019 11:37 pm

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, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26627
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Base 4.2.1 & MySQL text entry length update

Postby Spaltersar » Thu Mar 14, 2019 2:59 pm

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
Spaltersar
 
Posts: 2
Joined: Wed Mar 13, 2019 5:13 pm


Return to Base

Who is online

Users browsing this forum: No registered users and 3 guests