Is there a way to calculate total data size of column in MySql?

Question

Here is a solution how calculate table size, but what about column? Is there apporoach to calculate data which stored only for 1 column of table?

Note

The question is about data size, not data type size.

Answer 1

You can use below query that will return data size in bytes:

SELECT sum(char_length(comment)) FROM tbl_comments