utf 8 - View Japanese Characters in MySQL Workbench -

i tried this solution says

alter table title  character set utf8 collate utf8_unicode_ci; 

ok here screen shots might you.

update

here's happens when insert japanese characters.

update 2

show create table gives this

create table `productinfo` (   `pid` int(11) not null auto_increment,   `poperation` varchar(40) character set latin1 default null,   `year` year(4) default null,   `season` varchar(10) character set latin1 default null,   `pname` varchar(40) character set latin1 default null,   `category` varchar(40) character set latin1 default null,   `margin1` text character set latin1,   `margin2` text character set latin1,   primary key (`pid`) ) engine=innodb auto_increment=12 default charset=utf8 collate=utf8_unicode_ci 

just see default charset=utf8 collate=utf8_unicode_ci
but see query

select character_set_name, collation_name information_schema.columns table_schema = 'trac_data'     , table_name = 'productinfo'     , column_name = 'poperation'; 

gives

character_set_name collation_name

'latin1'            'latin1_swedish_ci' 

thats weird !

update 3

select hex(poperation),poperation trac_data.productinfo; 

gave 3f3f3f3f3f hex code actual '?' , not japanese character means no japanese characters being stored

you have mix of charsets in table structure. table uses utf8, column in question uses latin 1. have defined way. long have own charset column can change table's or schema's column thousand times. won't have effect on column. so, instead change column's charset either default (to use of table) or make using utf8 explicitely.

when alter column's charset existing data converted (if possible). wrong input stays wrong, have fill data again.