COALESCE uses CHAR instead of VARCHAR for mySQL.