P
P
PowerUSB2018-02-04 00:42:14
PHP
PowerUSB, 2018-02-04 00:42:14

What type of data field should be created in MySQL to store arrays?

There is a need in MySQL to store an array.
Question two questions:
1. If before sending the array to the muscle to process the function serialize($array) - what data type of the field should be in the muscle?
1. If before sending the array to the muscle, process the array with the function gzcompress(serialize($array)) - what data type of the field should be in the muscle?
Thanks in advance!

Answer the question

In order to leave comments, you need to log in

3 answer(s)
E
Ernest Faizullin, 2018-02-04
@PowerUSB

LONG TEXT

K
Kirill Nesmeyanov, 2018-02-04
@SerafimArts

Um, maybe still not soar the brain and use the JSON type? There is indexing, as it were, and the type is native ...

A
Alexander Aksentiev, 2018-02-04
@Sanasol

The most normal variant to make the table and to write down separately lines.
And that will be a collection of crutches over time.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question