Re: Latin1 to unicode character convert -- data are display with ?????

[Rick James]

What bytes did you put into the table? utf8 bytes? unicode? BIG5?

Assuming utf8, try this (and assuming tbl.txt is TEXT):
ALTER TABLE tbl MODIFY COLUMN txt BLOB;
ALTER TABLE tbl MODIFY COLUMN txt TEXT CHARACTER SET utf8;