Rectangle 27 5

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:

mysql_query("SET NAMES 'utf8'");

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.

please How do that in Java ? I have the same problem.

php - Insert Arabic data into mysql database - Stack Overflow

php mysql mysqli
Rectangle 27 0

mysql_query("SET character_set_results = 'utf8'");
mysql_query("character_set_client = 'utf8'");
mysql_query("character_set_connection = 'utf8'");
mysql_query("character_set_database = 'utf8'");

php - display arabic data from mysql database - Stack Overflow

php mysql sql database mysqli
Rectangle 27 0

It seems like your database configurations defined in database.php under Config folder is incorrect. Here encoding should be utf8 as well.

public $default = array(
        'datasource' => 'Database/Mysql',
        'persistent' => false,
        'host' => 'localhost',
        'login' => 'root',
        'password' => '************',
        'database' => 'projectimpossible',
        'prefix' => '',
        'encoding' => 'utf8',

php - Cakephp : How to save Arabic words into mysql table? - Stack Ove...

php mysql cakephp encoding arabic
Rectangle 27 0

change your table(columns) collation to utf8_general_ci and also in your html add

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

are you sure it will solve this have you read this anywhere ??

I just encoutered this issue 2 days before and I inserted arabic letters in my database by changing the column collation to utf8_general_ci


php - how to store arabic font in mysql - Stack Overflow

php mysql database character-encoding collation
Rectangle 27 0

You have to do the following things: 1.set the UTF-8 in your php script,like this:

ini_set('default_charset', 'utf-8');

php - how to store arabic font in mysql - Stack Overflow

php mysql database character-encoding collation
Rectangle 27 0

you have to do those three things and there you go

1- change the encoding of your editor programm which you use to UTF-8 .

  • 2- put in your php files this <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

3- put the collation in your database to UTF-8

in conclusion use UTF-8 everywhere.

I just noticed, that sometimes, when retrieving from the database, I get truncated strings, like I just get half of the string, why is that? and also, at a certain letter I get a small black square with question mark in it and stops at that place, why is that too?

nice that it works for you to get data in arabic and save them to database by arabic , now i see its other questions wich im not really see where is problem but i can just give some notes . about truncated strings try look if in this column in database is limited varchar length. exemple if your string is 35 long and in database you defined varchar(25) so you get it truncated. about i say that all letters works normal only maybe there is with it some fatha or kasra or damma which maybe not reconized, you must check and debug why happening this , i never met those things. Thanks

About the truncated strings, I have the varchar length to be 100, and all strings are for sure less than 50 even. As for the not recognized letters, I'll make sure now about the punctuations to see if its because of it. Thanks for your reply

I made sure there are no punctuations, but still I get the black diamond shape with question mark in it.

Arabic strings from php to MySQL tables - Stack Overflow

php mysql encoding xampp arabic
Rectangle 27 0

Here is a sample code that I tested with your words and it printed the suraNo/ayahNo/ayah that contains the word.

header('Content-type: text/html; charset=utf-8');
 die("DB Connection error: ".mysql_error());
mysql_query("SET NAMES utf8"); //IMPORTANT
<!DOCTYPE html>
 <html xmlns="" lang="ar" xml:lang="ar">
     <meta http-equiv="content-type" content="text/html; charset=UTF-8">
         <form method="get" accept-charset="UTF-8">
             Word Search: <input type="text" name="word"/>
             <input type="submit"/>
            if (!empty($word))
                $i = 0;
                $str = "SELECT * FROM $table WHERE AyahText LIKE '%$word%'";
                $query = mysql_query($str);
                while ($row = mysql_fetch_assoc($query))
                    echo "<br/>$i: ($row[SuraID], $row[VerseID]): $row[AyahText]";

You must call this after choosing database. When I removed this line I couldn't get any result.

mysql_query("SET NAMES utf8");

html - Can not search arabic in mysql Quran Database with php - Stack ...

php html mysql unicode
Rectangle 27 0

When you SET NAMES utf8 this will convert the characters to utf8 however if the default collation of the table is not utf8 maybe latin1 you will get data corruption. If you are set on using utf8 as your character encoding then you will have to mysqldump your table and change the encoding in the corresponding dump file and then re import your data. make sure you use a text editor that does not use character encoding itself when editing the dump file.

the collation of the table and column all of them are utf8_general_ci .the database are entered in Arabic but the problem when i extract them .

Why doesn't MySQL return my Arabic columns with the correct charset in...

php mysql utf-8 arabic
Rectangle 27 0

Try base_64 encoding the data before putting it into the db? It could be a special character causing corruption of the read.

@Shnage how about uuencode: You might need to investigate some of the algorithms yourself, this idea, though, is to encode it into a neutral state for db usage.

php - arabic data issue with mysql charecter - Stack Overflow

php mysql
Rectangle 27 0

This problem should be solved in an earlier stage. Arabic character do not fit in a non-unicode databasetable. That's the real problem.

You should use Unicode tables as well as a Unicode connection to your MySQL database.

Set the default character set of your table to utf8 and make sure the connection to your database is also using this character set:

$conn = mysql_connect($server, $username, $password);
mysql_set_charset("UTF8", $conn);

Check the character set of your current connection with:

echo mysql_client_encoding($conn);
create table user (
    // Your table definition
) default charset = UTF8

If you have done these things and add a user which contains arabic character to your table, you will see it is displayed correct. Now the comparison will be easy.

How to match junk characters in mysql database with arabic letters wit...

php mysql arabic
Rectangle 27 0

I'm not into php stuff but if you have some kind of connection string you should also set charset to utf8 within that string.

php - Storing arabic into mysql generate error - Stack Overflow

php mysql arabic
Rectangle 27 0

Nothing else in MYSQL except that you cant use full text search.

In PHP you need to use mb_string functions for doing any operation on texts.

I am Iranian and my language is Persian which is similar to Arabic in writing and I can confirm that you don't need any thing special. :)

*Edit: Forgot to say, You need to use this meta tag in your html:

<meta http-equiv="content-type" content="text/html; charset=utf-8" />

Also dont forget to save your php and html files in utf8, but you can use this tool in case you cant do that somewhere:

html - overview of issues in arabic and similar languages with PHP & M...

php html mysql arabic
Rectangle 27 0

<?php header('Content-Type: text/html; charset=utf-8'); ?>

i tried but doesn't solve the problem :'(

Arabic character "???????" on php and mysql - Stack Overflow

php mysql mysqli
Rectangle 27 0

It could be either or both of these problems:

Your output encoding is not set right. Put this in your .php file (near the top, before you send any output):

header("Content-Type: text/html; charset=UTF-8");

Your database connection/communication encoding (not quite sure what to call it) is not set right. Put this after you connect to the database but before you retrieve any data:

mysql_query('SET NAMES utf8');  // (or equivalent)

This ensures that communication between php and mysql is also done in utf8.

Odd, neither of these seemed to work. The column name is text, so I did SET text utf8

SET text utf8

Thanks. I did a lot of searching before I found this post. This worked perfectly. Thanks awm!

Convert Arabic/Japanese in mySQL to php? - Stack Overflow

php mysql utf-8 character-encoding phpmyadmin
Rectangle 27 0

$connect = mysqli_connect("$host", "$username", "$password", "$db_name");

and then

mysql_query("SET NAMES 'utf8'");

which is buggy, cause first I use mysqli_connect and then mysql_query (not mysqli_query).

php - Arabic text from android app to mysql database - Stack Overflow

php android mysql utf-8 arabic
Rectangle 27 0

mysql_query("set character_set_server='utf8'");
mysql_query("set names 'utf8'");

php - how to insert arabic letters in mysql - Stack Overflow

php mysql unicode internationalization arabic
Rectangle 27 0

Great it is working....... :) let me show you code.

CREATE TABLE `language_messages` (
  `lang_id` int(11) NOT NULL auto_increment,
  `en` varchar(500) NOT NULL,
  `ar` varchar(500) NOT NULL,
  PRIMARY KEY  (`lang_id`)

INSERT INTO `language_messages` VALUES (1, 'About Us', ' ');
INSERT INTO `language_messages` VALUES (2, 'Contact Us', '   ');
INSERT INTO `language_messages` VALUES (5, '', ' ');
$conn=mysql_connect(HOST,DB_USER,DB_PASS) or die(mysql_error());
$db=mysql_select_db(DB_NAME,$conn) or die(mysql_error());
mysql_query("set character_set_server='utf8'");
mysql_query("set names 'utf8'");

Step-3 View output in HTML page

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "">
<!--<html  dir="rtl" lang="ar" xml:lang="ar" xmlns="">-->
<html xmlns="">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Untitled Document</title>



$sql = "select * from language_messages";
$res = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_array($res))
        echo"<br />". $row['en'];   
        echo"<br />". $row['ar'];   


php - how to insert arabic letters in mysql - Stack Overflow

php mysql unicode internationalization arabic
Rectangle 27 0

Thanks alot guys, I've learned alot from your answers. However, I've found that what was causing the problem isn't MySQL, but PHP. The substring function for PHP doesn't play nicely with Arabic strings, and cut them off early, so I just had to remove it.

Can you publish the link to PHP bugtracker or another post describing this issue?

Issue in MySQL character limit - Stack Overflow

Rectangle 27 0

You need to set the collation in MySQL to the appropriate value (I'm guessing cp1256_general_ci) for sorting alphabetically in Arabic to work.

using cp1256 is not an option .. i want to use utf8 , i have a lot of ajax encoded witch doesnt work properly on cp1256 ..


order Arabic names in alphabetical order Mysql & php - Stack Overflow

php mysql