Insert Arabic words into mysql database

Question

I would like to insert/read Arabic words into mysql database

When I insert Arabic words from Chrome, I see them in DB ASCII
When I insert from FireFox, I see them in DB Unicode
See this picture from my DB: http://postimg.org/image/6ht95v671/

I need everything to be inserted in ASCII only

Note: I insert only from php form using POST method

http://stackoverflow.com/questions/279170/utf-8-all-the-way-through — Mihai, Dec 09 '13 at 01:50
I found the problem from the browser Encoding not from utf8 lol — Ahmed, Dec 10 '13 at 02:14

score 1 · Answer 1 · answered Dec 09 '13 at 01:55

For each new table you create, during creation, set its default character set to UTF8 and you should be good to go:

Here are the full docs

And here is some example sql

CREATE TABLE my_great_table('some_column' VARCHAR(1024)) DEFAULT CHARACTER SET = utf8;

Arabic characters can't be written in ASCII. It's an 8 bit character set that quite literally does not have the room to insert anymore characters into it besides 0-9, a-z, A-Z, punctuation, and some invisible command characters.

Here's a chart on ascii

I found the problem from the browser Encoding not from utf8 lol — Ahmed, Dec 10 '13 at 02:13

score 0 · Answer 2 · answered Feb 15 '14 at 12:35

You could always convert it to hex before putting it in the database

function strToHex($string){
    $hex='';
    for ($i=0; $i < strlen($string); $i++){
        $hex .= dechex(ord($string[$i]));
    }
    return $hex;
}

and then get the values by converting the hex to string

function hexToStr($hex){
    $string='';
    for ($i=0; $i < strlen($hex)-1; $i+=2){
        $string .= chr(hexdec($hex[$i].$hex[$i+1]));
    }
    return $string;
}

Insert Arabic words into mysql database

2 Answers2