Codeigniter Insert Non english character issue

Question

Hello I am inserting data in MySQL table using codeigniter by following query

$subcat_name="Hellome� testing";
$this->db->insert("table",array("name"=>"$subcat_name");

I am echoing its Equivalent SQL Query is following

INSERT INTO `table` (`name`) VALUES ('Hellome� testing');

Question:

Why data is not inserted in Database while SQL Query is proper?

try using utf8_encode($subcat_name) before you pass $subcat_name to the insert function — Skalbhile
– Skalbhile, Commented Jan 20, 2017 at 9:09
@Skalbhile It insert data but not properly inserted. It insert something like Hellome testing — Sadikhasan
– Sadikhasan, Commented Jan 20, 2017 at 9:19
Make sure that your script is saved with encoding utf_8. and your table collation is utf8_general_ci. For more details read stackoverflow.com/a/8281157/4050077 — ash__939
– ash__939, Commented Jan 20, 2017 at 13:19

Rana Ghosh · Accepted Answer · 2017-01-20 10:55:49Z

0

I think you should try using HTML NUMBER of the symbol which you want to instead of using � . Go to following link::

and find the symbol you want put the HTML NUMBER of that, i think that will work.

answered Jan 20, 2017 at 10:55

Rana Ghosh

4,6745 gold badges25 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

I am trying to insert Hellome� testing string in Database but not inserted