mysql存汉字为问号,Codeiginter MySQL将汉字存储为问号

When I type in chinese characters to store in the database, it becomes ??? question marks instead.

Anyone can help me with this?

My codeigniter config settings for char set is

$db['default']['char_set'] = 'utf8';

$db['default']['dbcollat'] = 'utf8_unicode_ci';

my meta tag is as below as well

解决方案

This issue occur when you have not set the table charset to utf8. Check your table and set its Chartset to utf-8 and collation to utf8_general_ci or utf8_unicode_ci (which is best for your language :) ).

This will fix the issue.

Thank you