Encoding Php to DB

Question

I've got some problems with the codification on my db. Db and tables are set with utf8_general_ci, and all PHP web pages have some header with this encoding. From FORM I've to insert something, that is perfectly shown on web page, but on db figures like : Ã weÃ rewÃ fÃ dsÃ fewÃ

After db connection I've made some:

$connection->set_charset("utf8_general_ci");

Someone can help me with this? Thank you everyone!!

I think you should follow the link http://stackoverflow.com/questions/202205/how-to-make-mysql-handle-utf-8-properly — Mumtaz Ahmad, Mar 09 '15 at 11:33
I've seen it before ask question. This wasn't helpful. Thank you — Altair, Mar 09 '15 at 11:35

score 0 · Answer 1 · answered Mar 09 '15 at 11:27

0

From your insert query you can use utf8_encode($_POST['form_data']); which encode special characters.

answered Mar 09 '15 at 11:27

makjal

15
1
9

Thanks for your comment...i've tried, result on db changed, but is like this: ÃƒÂ ÃƒÂ ÃƒÂ ÃƒÂ asÃƒÂ fÃƒÂ eÃƒÂ eÃƒÂ¨ÃƒÂ¨ – Altair Mar 09 '15 at 11:45
ohh..don't know much abt is. but i used collation utf8_unicode_ci – makjal Mar 09 '15 at 11:54

Encoding Php to DB

1 Answers1