Geek Answers Handbook

Error in encoding mysql & # 8594; How can I convert it to another?

I started the website some time ago using the wrong CHARSET in my database and website. HTML was set to ISO ... and DB to Latin ..., the page was saved to Western Latin ... a big mess.

The site is in French, so I created a function that replaced all accents like "é" with " é". Which temporarily resolved the problem.

I just found out about programming, and now my files are saved as Unicode UTF-8, HTML is in UTF-8, and my MySQL table columns are set to ut8_encoding ...

I tried to shift the emphasis to "é" instead of " é", but I get the usual encoding problems with (?) Or weird “Ã ¢” characters both in MySQL and when the page is displayed.

I need to find a way to update my sql using a function that clears strings so that it can finally return to its normal state. At the moment, my function looks like this, but does not work:

function stripAcc3($value){

 $ent =   array(
          'à'=>'à', 
          'â'=>'â', 
            'ù'=>'ù', 
          'û'=>'û',
            'é'=>'é', 
          'è'=>'è', 
          'ê'=>'ê', 
            'ç'=>'ç', 
            'Ç'=>'Ç', 
            "î"=>'î', 
            "Ï"=>'ï', 
            "ö"=>'ö', 
            "ô"=>'ô', 
            "ë"=>'ë', 
            "ü"=>'ü', 
            "Ä"=>'ä',
            "€"=>'€',
          "′"=> "'",
          "é"=> "é"
        );

    return strtr($value, $ent);
}

Any help is appreciated. Thanks in advance. If you need a code, let me know which part.

UPDATE

If you want to receive bonus points, I need detailed instructions on how to do this. Thank.

+5
source share
6 answers

, :

function makeStringUTF8($data)
{
    if (is_string($data) === true)
    {
        // has html entities?
        if (strpos($data, '&') !== false)
        {
            // if so, revert back to normal
            $data = html_entity_decode($data, ENT_QUOTES, 'UTF-8');
        }

        // make sure it UTF-8
        if (function_exists('iconv') === true)
        {
            return @iconv('UTF-8', 'UTF-8//IGNORE', $data);
        }

        else if (function_exists('mb_convert_encoding') === true)
        {
            return mb_convert_encoding($data, 'UTF-8', 'UTF-8');
        }

        return utf8_encode(utf8_decode($data));
    }

    else if (is_array($data) === true)
    {
        $result = array();

        foreach ($data as $key => $value)
        {
            $result[makeStringUTF8($key)] = makeStringUTF8($value);
        }

        return $result;
    }

    return $data;
}

, :

  • (, ) SQL/CSV *
  • , , / , UTF-8.

* :

file_put_contents('utf8.sql', makeStringUTF8(file_get_contents('latin.sql')));

, .

+5

, , WP:

http://codex.wordpress.org/Converting_Database_Character_Sets

, WP / , UTF8. , UTF8.

, Latin1 UTF8.

+2

, , , iconv. , , UTF-8 -1.

0

, ,

  • UTF-8

  • , HTML

a

html_entity_decode($string, ENT_QUOTES, "UTF-8");

UTF-8.

0

, utf-8, utf-8.

$this->db = mysql_connect(MYSQL_SERVER,DB_LOGIN,DB_PASS);
mysql_set_charset  ('utf8',$this->getConnection());
0

UTF-8, , - UTF-8. , , :

" utf8";

Personnaly connect.inc.php, . , UTF-8 !

mysql_set_charset , , , .

, latin1 UTF-8, latin1 . UTF-8, . , artile ( ): http://www.noidea.ca/2009/06/15/comment-convertir-une-db-de-latin1-a-utf8/

, , , .

0

More articles:


All Articles