Mysql and Navicat Table Design

sam - Apr 16, 2008 at 11:11 PM
 Vincent - Aug 20, 2010 at 02:14 PM

I am really new to this . I am using Navicat with MySql. I have created a Database and a table. However, when I try to set a field type to text and the length to say 20 it always reverts back to 0 and will not import any data. It is probably something I am doing but does anyone have any ideas.

2 responses

Ridiculously old thread, but the answer may help someone even years later.

The field type "text" doesn't have a length in mysql. It is automatically allows for a really large amount of data of variable length (iirc). If you want to specify a length for a textfield, then you might be looking for the datatype "varchar" which you can set to a number between 1 and 255, I believe.