Storage calculations and VARCHAR

How VARCHAR Stores Data Calculating Storage Needs To estimate table size, multiply row count by sum of column sizes plus overhead (typically 20-40 bytes per row for metadata). With these storage costs in mind, here are the key rules to follow when sizing your columns: Remember that UTF-8 characters can use 1 to 4 bytes each, so character count and byte count may differ for international text.