CODEWITHSUNDEEP
mysqlcodeigniterutf-8character-encoding
kkh
kkh

Reputation: 4869

Codeiginter mysql storing chinese characters as questions marks

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

<meta http-equiv="content-type" content="text/html; charset=utf-8" />

Upvotes: 2

Views: 2256

Answers (1)

Altaf Hussain
Altaf Hussain

Reputation: 5202

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

Upvotes: 3

Related Questions