Arabic Language conversion php to mysql

Question

<meta http-equiv="Content-Type" content="text/html;charset=utf-8">
mysql_query("update `mudasser`
             set `name`='$name',
                `ar_name`='$ar_name',
                `address`='$address',
                `type`='$type',
                `telephone`='$telephone',
                `date_added`='$date',
                `image`='$file'
            where `id`='$id'"

when i echo the query this is the result

update `mudasser` set `name`='Boknan', `ar_name`='بوكنان', `address`='E2', `type`='Abaya Galabia', `telephone`='2535338', `date_added`='2015-06-01 08:54:11', `image`='Boknan.jpg' where `id`='128'

You can see the arabic name appearing correct but in the database the arabic name is somehow like this ???????

If i run this query directly in mysql, it runs perfect and it is also reading correct arabic in php page.

For reference i am using <meta http-equiv="Content-Type" content="text/html;charset=utf-8"> in php and also using utf-8 in db.

I have searched the net and Stackoverflow but i cant find any answer.

Uhhhmmm @leggendario I think you edited out an important part of the question... (the question marks) — PeeHaa, Jun 01 '15 at 13:05
Your current character encoding is probably set incorrectly. — Seiyria, Jun 01 '15 at 13:05
@sameed when you say "somehow like this" were those question marks meant to be there? As in, that is what you see? — PeeHaa, Jun 01 '15 at 13:06
the code is working perfect otherwise, the problem is just with arabic. if i write this query in mysql it runs perfectly fine. but through PHP its not entering the correct arabic value — Sameed, Jun 01 '15 at 13:09
yes those were the question marks that meant to b there, part of question — Sameed, Jun 01 '15 at 13:09

MrSimpleMind · Accepted Answer · 2015-06-03T07:55:25.537

1

Try this before executing the update query.

either

mysql_query("SET NAMES utf8");

or

mysql_query("SET NAMES utf8mb4");

utf8mb4 is preferred. Which was introduced in MySQL 5.3.3, use it if possible.

read more about difference in UTF8 and UTF8mb4 and how to switch to mb4

edited Jun 03 '15 at 07:55

answered Jun 01 '15 at 13:06

MrSimpleMind

7,890
3
40
45

1

that is perfect.it has solved the query. million thanks – Sameed Jun 01 '15 at 13:13

score 0 · Answer 2 · answered Jun 01 '15 at 13:06

0

Please check your table's CHARSET and COLLATE Properties.

For columns check "Encoding" and "Collation" properties.

CHARSET/Encoding should be utf8 Collate/Collation should be utf8_bin

answered Jun 01 '15 at 13:06

Rishav Rastogi

15,484
3
42
47

its mentioned they are encoded and collated same as u suggested – Sameed Jun 01 '15 at 13:10

score 0 · Answer 3 · answered Jun 01 '15 at 13:09

0

ar_name need to be a nvarchar type
Put N in front of the arabic characters - N'بوكنان'

answered Jun 01 '15 at 13:09

Liu

970
7
19

The N is optional in MySQL. – Rick James Jun 26 '15 at 04:40

Arabic Language conversion php to mysql

3 Answers3