explicitly set mychar column collation; otherwise it would always defaults to utf8_general_ci, even if the database and table uses another collation.