mysql | What is difference between SET and TEXT field types?

Question

What is difference between SET and TEXT column types? I know that maximum length of SET column type is 64 elements. If I will use TEXT column type can I avoid this limit?

score 2 · Accepted Answer · answered May 16 '15 at 07:02

2

set and text are two completely different things.

A set allows you to specify which values (up to 64) are allowed in a column, and input values that contain any unique combination of these values. text, on the other hand, is just a really long string.

answered May 16 '15 at 07:02

Mureinik

297,002
52
306
350

What is faster for FIND_IN_SET command. Search in numerical SET or search in the numerical TEXT field??? – XTRUST.ORG May 16 '15 at 09:39
Depends on the specific data, of course, but as a rule of thumb, using a numerical `SET` should be considerably faster. – Mureinik May 16 '15 at 09:41

score 1 · Answer 2 · edited May 23 '17 at 11:51

1

Yes, you can avoid this limit (64 elements), But TEXT type has its limits:

Maximum length (TEXT type): 65,535 (216−1) bytes = 64 KiB

For more information about maximum storage sizes types, see there:

TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes

edited May 23 '17 at 11:51

Community

1
1

answered May 14 '15 at 21:50

mysql | What is difference between SET and TEXT field types?

2 Answers2