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
Base 4.2.1 & MySQL text entry length update
-
- Posts: 2
- Joined: Wed Mar 13, 2019 5:13 pm
Base 4.2.1 & MySQL text entry length update
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
Re: Base 4.2.1 & MySQL text entry length update
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 2
- Joined: Wed Mar 13, 2019 5:13 pm
Re: Base 4.2.1 & MySQL text entry length update
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
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