Insert Arabic data into mysql database

Question

i tried entering Arabic text and insert it into mysql database using php, when print the row, all rows that in arabic looks like :

i set my database to: Character set: utf8 -- UTF-8 Unicode Collation: utf8_general_ci

and every field in database: Character set: utf8 Collation: utf8_general_ci

i need to solve this problem and i appreciate all answers ..

You should also query `set names utf8` in script to set character set for client. — Maxim Khan-Magomedov, May 15 '13 at 21:17
Are you using a utf-8 character set when outputting? For example, if you're using HTML, are you using something like this at the top: ` ` — Mark Ormston, May 15 '13 at 21:18
i'm new in php, please tell me how to 'set names utf8' in script ? — Mohammed F. Ghazo, May 15 '13 at 21:22
In a tool such as PHPmyAdmin, does it renders Arabic text like that? — SaidbakR, May 15 '13 at 21:22
ok, thanks @ Mark Ormston, i didn't use it, i put the code u posted at the top and the arabic data displayed — Mohammed F. Ghazo, May 15 '13 at 21:29

SaidbakR · Accepted Answer · 2016-07-10T10:17:04.333

5

Do the following:

Include the following query in every page of your application mysql_query("SET NAMES 'utf8'");
Be assured that your web pages are utf-8 encoded by the following meta tag:

edited Jul 10 '16 at 10:17

answered May 15 '13 at 21:30

SaidbakR

i'm new, where i put this query in the code ??`mysql_query("SET NAMES 'utf8'");` – Mohammed F. Ghazo May 15 '13 at 21:39
Make a PHP file called -for example- inc.php and then place this code inside it, then in every file of your script make sure you included this file. – SaidbakR May 15 '13 at 21:57
please How do that in Java ? I have the same problem. – Souad Jun 02 '13 at 17:31
@Souad Unfortunately, I don't know how to implement this in Java. – SaidbakR Jun 02 '13 at 17:41

1 Answers1