Encoding while inserting in mysql

#native_company# #native_desc#

#native_cta#

This site is best viewed in a modern browser with JavaScript enabled.

gemswebs

Hi all,,

I have a task to insert arabic string in database ..

If i inserted arabic from any form in the website,, the arabic is stored in arabic (normal).

But the problem is that in my form if i inserted arabic string,, it stored as a strange characters (bad encoding).

firesnaker

Check your database encoding. The database encoding must be specific to Arabic if you intend to store Arabic characters.

gemswebs

firesnaker;1299493 wrote:
Check your database encoding. The database encoding must be specific to Arabic if you intend to store Arabic characters.

Well.. i am inserting in the same field..

When i insert arabic from the website form it appear well..
But when i insert from my form ( the same word into the same field in the database ) it turns to bad encoding

firesnaker

I see, well, encoding is a difficult problem. One way I can think of is to make sure all encoding are the same, from the html, php, apache and mysql.

So, check your html file vs the website html file for encoding meta tag. See if there is any different.

Then, if you are on different server, development vs production, check for the locale encoding environment.

Of course, since you say they are from the same database, checking mysql encoding is not necessary.

If, all the above fails, you have a tricky problem.

Google is not much help. But I found a link related to MySQL that maybe of interest:
https://www.bluebox.net/insight/blog-article/getting-out-of-mysql-character-set-hell

Good luck!

NogDog

Here's pretty much everything I know about the topic: http://www.ebookworm.us/2008/10/03/utf8-in-php-and-mysql/

unasAquila

This can be a bit overkill but works well

$mysqli = new mysqli('127.0.0.1', 'username', 'password', 'database');

//check connection 
if (mysqli_connect_errno()) { 
    printf("Connect failed: %s\n", mysqli_connect_error()); 
    exit(); 
}

$mysqli->query("SET character_set_connection = utf8"); 
$mysqli->query("SET character_set_client = utf8"); 
$mysqli->query("SET character_set_results = utf8");
$mysqli->query("SET COLLATION_CONNECTION = 'utf8';");
$mysqli->query("SET NAMES utf8");
$mysqli->set_charset("utf8");

$string = "&#1605;&#1585;&#1581;&#1576;&#1575; &#1571;&#1589;&#1583;&#1602;&#1575;&#1574;&#1610; &#1580;&#1610;&#1583;&#1577;";
//$string = urlencode($string); //can be good also

$query = "INSERT INTO `arabic_table` (`string`) VALUES ('{$string}')";
$mysqli->query($query);

$select = "SELECT `string` FROM `arabic`";
$querys = $mysqli->query($select);

if ($result = $querys) { 
    while ($row = $result->fetch_row()) { 
        mb_check_encoding($row[0], 'utf-8'); 
        echo $row[0] . "\n"; 
    } 
    $result->close(); 
}

also rember to make sure that the display page has these

<html dir="rtl" lang="ar">
	<meta charset="utf-8">

and you should be ok

gemswebs

Thanks all,,

SET NAMES.... sloved it.