C
C
cyberlog2016-09-04 18:28:40
MySQL
cyberlog, 2016-09-04 18:28:40

MySql and allocated memory for different data types, with different encodings - the state of the art, where can I see the pivot table?

The manual says that 8 bytes are allocated for CHAR (8), but now there is utf-8.
Some say that 1 utf-8 character can take from 3 to 4 bytes, another says that 6 ...
Where can I see a pivot table with up-to-date data, such data type = so many bytes?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
SagePtr, 2016-09-04
@SagePtr

Something like this: https://ru.wikipedia.org/wiki/UTF-8#.D0.94.D0.B8.D...
And under the regular utf-8 field in MySQL, 3 bytes per character are allocated, and utf8mb4 - 4 bytes per character. Longer unicode sequences are not currently used and are not supported by MySQL.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question