Persian character's issue in mysql database

Question

When I insert Persian data to database, data will save like this: †Ø¯Ø± 50 Ù„ÛŒØªØ±ÛŒ

But when I read data from database and echo it on the web, they are Ok.

I need to read data in my database directly. what is your solution?

Mysql setting:

Server connection collation: UTF8_general_ci

Html file charset is utf8.

score 7 · Answer 1 · answered Aug 10 '14 at 12:07

7

I had a same issue,this code: mysqli_set_charset($con, "utf8"); solved my problem!

answered Aug 10 '14 at 12:07

Hamed Ghadirian

6,159
7
48
67

score 4 · Answer 2 · answered Mar 21 '15 at 10:55

you should use this code

$yourConnection->set_charset("utf8");

for example

function insertUser($inUN,$inP,$inFN,$inLN,$inE,$inD)
    {   
        $servername="localhost";
        $username="mnr";
        $password="milad1373";
        $databacename="mnr01";

        $conn = new mysqli($servername, $username, $password, $databacename);
        if ($conn->connect_error) {
            die("Connection failed: " . $conn->connect_error);
        } 
        $conn->set_charset("utf8");

        $sql = "INSERT INTO chuser (username, passWord, fname,lname,email,date)
        VALUES ('$inUN', '$inP','$inFN','$inLN', '$inE','$inD')";
        if ($conn->query($sql) === TRUE) {
            echo "New record created successfully";
        } else {
            echo "Error: " . $sql . "<br>" . $conn->error;
        }

        $conn->close();
    }

i had this problem but it resolved by this code and for more information go to this link

score 2 · Answer 3 · edited May 23 '17 at 12:02

2

Make sure you have executed

SET character_set_results=utf8

SET NAMES 'utf8'

before you send any INSERT command.

Have a look at this question for more information. I think it may help;

UTF8 All The Way Through

edited May 23 '17 at 12:02

Community

1
1

answered Dec 11 '13 at 13:08

mehmetseckin

3,061
1
31
43

score 0 · Accepted Answer · edited May 23 '17 at 12:10

0

solved:

in connection

<?php
 $dbLink = mysql_connect($argHost, $argUsername, $argPassword);
    mysql_query("SET character_set_results=utf8", $dbLink);
    mb_language('uni'); 
    mb_internal_encoding('UTF-8');
    mysql_select_db($argDB, $dbLink);
    mysql_query("set names 'utf8'",$dbLink);
?>

source: PHP mysql charset utf8 problems

edited May 23 '17 at 12:10

Community

1
1

answered Dec 12 '13 at 05:43

Saman May

71
1
3

score 0 · Answer 5 · edited Jul 08 '18 at 13:43

You should change your collation to utf8_unicode_ci in your phpmyadmin:

Go you your localhost/phpmyadmin
Select your database
Next to your database there's an small icon click on that
Click on change
Change your collation to utf8_unicode_ci.
Insert this code to your php file.

if (!$connection->set_charset("utf8")) {
    printf("Error loading character set utf8: %s\n", $mysqli->error);
    exit();
} else {
    printf("Current character set: %s\n", $connection->character_set_name());
}

Persian character's issue in mysql database

5 Answers5

Linked