How to count all characters in all rows of a field in MySQL?

For the number of bytes . . .

select sum(length(your_column_name)) 
from your_table_name;

For the number of characters . . .

select sum(char_length(your_column_name)) 
from your_table_name;

The char_length() function accommodates multi-byte characters; five two-byte characters will return as 5.

Just sum all the lengths for the field

SELECT SUM(CHAR_LENGTH(field)) FROM table

Related