Page 1 of 1

[Solved] MySQL limited Length of VarChar field

Posted: Fri May 28, 2010 4:44 pm
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

Re: MySQL limited Length of VarChar field

Posted: Fri May 28, 2010 7:11 pm
by RPG
Hello

Is there a limit in your text control? So the problem is in your form?
I don't use MySQL

Romke

Re: MySQL limited Length of VarChar field

Posted: Fri May 28, 2010 7:17 pm
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)