MySQL DECIMAL storage. MySQL assigns the storage for integer and fractional parts separately. MySQL uses binary format to store the DECIMAL values. It packs 9 digits into 4 bytes. For each part, it takes 4 bytes to store each multiple of 9 digits. The storage required for leftover digits is illustrated in the following table: Apr 06, 2010 · A decimal with 8 digits, 7 of them being after the decimal point Something like, 1.234567, but not 12,34567 because out of the 8 digits, 7 of them must be on the right hand side of the decimal point. If you want 8 digits and be able to represent 10, you'd need at least decimal(8, 6) Luc Nov 02, 2020 · However, for MySQL versions 5.5.3 and MariaDB 5.5 on forward, a new MySQL-specific encoding 'utf8mb4' has been introduced, and as of MySQL 8.0 a warning is emitted by the server if plain utf8 is specified within any server-side directives, replaced with utf8mb3. The rationale for this new encoding is due to the fact that MySQL’s legacy utf-8 ...