Save your time, use CONCAT_WS
SELECT SUM(CHAR_LENGTH(CONCAT_WS('', column1, column2, column3, column4))) as bsize FROM table1