Storing a binary array in MySQL

Question

I have an array of values ​​called A, B ... X, Y, Z. Pleasure, although it would have 26 columns in the table, I cannot help but feel that there is a better way. I considered creating a second table with the row id value from the first table, the identifier of the element in the array, and then the boolean, but it seems clumsy and confusing.

Is there a better way?

Answer 1

The short answer is no. Long answer, it depends.

You can store binary data in several ways - abuse the number using BINARY or VARBINARY, using BLOB or TINYBLOB, etc. BINARY types will usually be faster than BLOB types if your data is known.

. , , , , , , OR, XOR NOT. , , . , .

, , . - , .

. , , - ? - ?

Answer 2

?

, MySQL SET.

Answer 3

You can try to save it as TINYBLOB or even UNSIGNED INT, but you will have to do the masking in your code.

Answer 4

You can save it as a string and use the text manipulation functions to (re) create your array.