[Solved] MySQL limited Length of VarChar field

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
evwool
Volunteer
Posts: 401
Joined: Fri Oct 09, 2009 9:40 pm
Location: UK

[Solved] MySQL limited Length of VarChar field

Post by evwool »

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
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
RPG
Volunteer
Posts: 2250
Joined: Tue Apr 14, 2009 7:15 pm
Location: Netherlands

Re: MySQL limited Length of VarChar field

Post by RPG »

Hello

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
evwool
Volunteer
Posts: 401
Joined: Fri Oct 09, 2009 9:40 pm
Location: UK

Re: MySQL limited Length of VarChar field

Post by evwool »

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
Post Reply