I created a db in MySQL then connected to it via BASE.
I opened the Base db with a 2click and I created a table, tblinstruction, and specified in Table Design that one of the fields be Text (VARCHAR) and have a Length of 255
But it only lets me type in 26 characters.
Can I do anything about this?
In MySql when I look at the table using the command
describe tblinstruction;
it shows the field has having a lenght of 255
[Solved] MySQL limited Length of VarChar field
[Solved] MySQL limited Length of VarChar field
Last edited by evwool on Fri May 28, 2010 7:18 pm, edited 1 time in total.
OpenOffice 3.1.1 on Windows XP and on Windows 7 Starter
Re: MySQL limited Length of VarChar field
Hello
Is there a limit in your text control? So the problem is in your form?
I don't use MySQL
Romke
Is there a limit in your text control? So the problem is in your form?
I don't use MySQL
Romke
LibreOffice 7.1.4.2 on openSUSE Leap 15.2
Re: MySQL limited Length of VarChar field
You clever man! That was it! I've never had a text control do that before (but then I've never created a form in a MySql connected db before either)
OpenOffice 3.1.1 on Windows XP and on Windows 7 Starter