mysql PHPMyAdmin isn't accepting Arabic Language

Asked Jun 07 '16 at 18:06

Active Jun 07 '16 at 20:59

Viewed 18 times

I am using an android app that connects on php files that insert values in mysql database. the problem is the database isn't saving the arabic input correctly but in strange characters. I searched the internet and tried to set everything to UTF-8 .. but it seems there is something missing .. what is it?

edit: this is solved by adding the below command after connecting to the mysql:

$mysqli->set_charset('utf8mb4');

I changed the database collation to utf8_general_ci as per below pic:

(I don't know how to alter Latin1_Swedish_ci) ?!!
changed the table collation to utf8_general_ci.
Changed the column collation to utf8_general_ci.
set the php auditor to utf-8.
I put that in the php file start:
I also used utf8 in coding my variables in the android app before sending to php files.

edited Jun 07 '16 at 20:59

hjpotter92

78,589
36
144
183

asked Jun 07 '16 at 18:06

Sheriff Said Elahl

2

what you didn't post (or probably didn't try) was to pass utf-8 to the connection before querying; try that. As outlined in http://stackoverflow.com/questions/279170/utf-8-all-the-way-through – Funk Forty Niner Jun 07 '16 at 18:07
http://stackoverflow.com/questions/6859018/save-data-in-arabic-in-mysql-database – Amit Ray Jun 07 '16 at 18:08
PHPMyAdmin *is not* a database. It is a web interface for your MySQL database. – Jay Blanchard Jun 07 '16 at 18:18
1

@Fred-ii- thanks man, you saved my day :) – Sheriff Said Elahl Jun 07 '16 at 18:18
1

@SheriffSaidElahl You're most welcome, *cheers!* ;-) – Funk Forty Niner Jun 07 '16 at 18:19
The "database" setting is not relevant; check the column/table with `SHOW CREATE TABLE`. – Rick James Jun 09 '16 at 15:30

mysql PHPMyAdmin isn't accepting Arabic Language

0 Answers0