Not sure on what length Text field in mysql should have [duplicate]

Question

In my Mysql DB I have a field which is used to store user-inputted text, and therefore set as Text and not varchar.

A user can input a maximum of 3000 characters which is then saved into the Text field.

So, should I give the Text field an length of 3000 in Mysql? Since thats the maximum characters a user can submit. More or less like length with varchar works.

Thanks in advance,

user3792628 · Accepted Answer · 2014-07-01 09:44:25Z

0

A MySQL text field can store a maximum of 65535 characters (using single-byte characters).

You don't need to specify a text field's length like you do for varchar.

answered Jul 1, 2014 at 9:44

user3792628

1673 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user2722667 Over a year ago

But in order to add a Index key to the text field. Do I have to set a length first? Coz right now I cant add a index key to the text field, or that might be just coz it is a text field.

user3792628 Over a year ago

TEXT columns can be indexed but a prefix length must be given. Example: CREATE UNIQUE INDEX index_name ON myfield (key(10)); This example indexes just the first 10 characters.

Collectives™ on Stack Overflow

Not sure on what length Text field in mysql should have [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related