How to save text field input to table as utf8 encoded data automatically?

Question

How to save text field input into mytable as utf8 encoded data, since textarea input automatically changing into utf8 encoded data,

You should make sure you're using the correct charset in your page. Set the `` in your header. The table in your database should of course also have a utf-8 encoding. — Cyclonecode, Oct 07 '13 at 09:23

score 1 · Answer 1 · answered Oct 07 '13 at 09:27

1

SET NAMES utf8;

That will set the next queries to be saved AS UTF-8. Execute it before your actual INSERT or UPDATE

Be warned that if the sending page has a different charset, it would lead to character encoding errors.

answered Oct 07 '13 at 09:27

zonzon

score 0 · Accepted Answer · edited May 23 '17 at 11:57

Firstly, make sure that your database table is set to character set UTF-8.

Secondly, set the page your are submitting data from as UTF-8 with the following meta tag:

<head>
<meta charset="UTF-8">
</head>

Then when making your connection to the database you can execute the following query to set any subsequent queries to the UTF-8 character set too:

query("SET NAMES utf8");

2 Answers2