C
C
crayes232016-09-24 06:23:54
MySQL
crayes23, 2016-09-24 06:23:54

Varchar(5000) vs text?

Good day.
Please tell me what type of field (MySQL) is preferable if the text is large?
for example 5-10k characters
VARCHAR(5000) or TEXT?
using Mariadb 10.1

Answer the question

In order to leave comments, you need to log in

2 answer(s)
R
romy4, 2016-09-24
@romy4

Depends on the destination and subsequent used indexes on the field.

A
Artemy, 2016-09-25
@MetaAbstract

Prefer text and do not select this field in collections.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question