PHP MYSQL Insert Data in Arabic Language

Question

I am trying to insert some Arabic Language data into MySQL using PHP and an HTML form. When I insert the data in to MYSQL table, the table field represents data as Ù…Ø±ØØ¨Ø§ Ø§Ù„Ø¹Ø§Ù„Ù….

But when I access the same data with PHP and show it in my webpage, it shows the correct data. I am using:

http-equiv="Content-Type" content="text/html; charset=utf-8"

meta tag in my web page to show Arabic data. My question is why my data looks like this: Ù…Ø±ØØ¨Ø§ Ø§Ù„Ø¹Ø§Ù„Ù… in MySQL table, and how should I correct it.

possible duplicate of [PHP Mysql Json and Arabic language](http://stackoverflow.com/questions/11262561/php-mysql-json-and-arabic-language) — eggyal, Jun 29 '12 at 14:32
I have found this article to be helpful: http://www.bluebox.net/news/2009/07/mysql_encoding/ — Mark Eirich, Jun 29 '12 at 14:43

score 20 · Accepted Answer · edited Jul 01 '12 at 01:00

20

You have to do both of the following:

Make sure your database encoding and collation is utf8_general_ci (both for the field itself and the table as well as the database).

Send two commands right after establishing a connection to the database:

mysql_query("SET NAMES utf8;");

mysql_query("SET CHARACTER_SET utf8;");

edited Jul 01 '12 at 01:00

hakre

193,403
52
435
836

answered Jun 29 '12 at 19:39

Ansari

8,168
2
23
34

score 3 · Answer 2 · answered Jul 01 '12 at 01:42

You aren't mentioning the MySQL version that you are using, but if using 5.0.7 or later, as per the official PHP documentation:

This is the preferred way to change the charset. Using mysql_query() to set it (such as SET NAMES utf8) is not recommended. See the MySQL character set concepts section for more information.

e.g., ^{Assuming that you are using the mysql_query extension.}

<?php
  $link = mysql_connect('localhost','user1','pass1',TRUE);

  mysql_selectdb('db1', $link);

  mysql_set_charset('utf8',$link); 
?>

Other considerations:

The files being used should be encoded with UTF-8
The database, table and field should all be encoded and using the collation utf8_general_ci
The PHP headers and HTML headers should also be set to UTF-8

As a side note, The use of mysql_query extension is discouraged. Instead, the MySQLi or PDO_MySQL extension should be used.

See also MySQL: choosing an API guide and related FAQ for more information.

score 2 · Answer 3 · answered Jun 29 '12 at 14:39

2

You should use this line:

@mysql_query("SET NAMES 'utf8' ");

See this function:

function _connect($user, $pass, $host)
{
    $conn = mysql_connect($host, $user, $pass);

    if (!$conn)
        return false;

    @mysql_query("SET NAMES 'utf8' ");
    //more....
}

answered Jun 29 '12 at 14:39

Soroush Khosravi

887
2
11
30

Please add some explanation to your answer such that others can learn from it – Nico Haase May 27 '20 at 05:58

score 0 · Answer 4 · edited Jul 21 '15 at 14:16

0

Your database should be utf8 supported. Try with utf8_general_ci or utf8_unicode_ci

edited Jul 21 '15 at 14:16

Adnan D.

430
1
5
19

answered Jun 29 '12 at 14:06

nbhatti2001

353
2
7
33

score 0 · Answer 5 · edited Jul 09 '12 at 23:41

0

try this:

@mysql_query("set global character_set_results=utf8");

edited Jul 09 '12 at 23:41

Taz

3,718
2
37
59

answered Jun 29 '12 at 17:18

luchopintado

899
11
15

Please add some explanation to your answer such that others can learn from it – Nico Haase May 27 '20 at 05:58

score 0 · Answer 6 · answered Jul 17 '18 at 20:45

0

try to change server and db and table collation

for example

ALTER DATABASE "DBNAME" CHARACTER SET utf8 COLLATE utf8_general_ci;

answered Jul 17 '18 at 20:45

Ahmed Salem

57
6

Please add some explanation to your answer such that others can learn from it - are you sure this is only a problem on the database side? – Nico Haase May 27 '20 at 05:58

score 0 · Answer 7 · edited May 27 '20 at 12:55

0

The following works for me:

mysqli_set_charset($this->connect,'utf8'); mysqli_query($this->connect, "SET NAMES 'utf8'"); mysqli_query($this->connect, 'SET CHARACTER SET utf8');

Moreover, your table must be (utf8_general_ci) in the structure field.

edited May 27 '20 at 12:55

Aditya Prakash

1,549
2
15
31

answered May 27 '20 at 02:25

ahmad almasri

59
3
11

Please add some explanation to your answer such that others can learn from it – Nico Haase May 27 '20 at 05:57
1

Please add some explanation to your content,[How do I write a good answer?](https://stackoverflow.com/help/how-to-answer) – Willie Cheng May 27 '20 at 09:20

score -1 · Answer 8 · edited Nov 25 '12 at 07:35

Now PHP and MYSQL support any language. Use this function in database connectivity .

$this->links = mysql_connect(DB_SERVER,DB_SERVER_USERNAME,DB_SERVER_PASSWORD);  
mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', 
  character_set_connection = 'utf8', character_set_database = 'utf8', 
  character_set_server = 'utf8'", $this->links);

MYSQL database table field should be Collation=utf8_general_ci

PHP MYSQL Insert Data in Arabic Language

8 Answers8

Linked