Mysql and Navicat Table DesignClosed

Question

Hello,

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.

bethy · Accepted Answer

hello

Vincent · Answer

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.

Mysql and Navicat Table Design

2 responses

Similar discussions

Subscribe To Our Newsletter!