Convert accents from MySQL to no accent in a web page using PHP

Question

I'm currently stuck trying to convert names like "Kévin" into "Kevin" then "KEVIN".

Current database is set to Latin1_swedish_ci. It does not work if the name comes from MySQL and I don't know why. I've already tryed to change latin1 to utf8_general_ci and nothing change.

The name Kévin is writed as "Kévin" into MySQL.

Fonction in use:

function strToNoAccent($var) {
    $var = str_replace(
    array(
    'à', 'â', 'ä', 'á', 'ã', 'å',
    'î', 'ï', 'ì', 'í', 
    'ô', 'ö', 'ò', 'ó', 'õ', 'ø', 
    'ù', 'û', 'ü', 'ú', 
    'é', 'è', 'ê', 'ë', 
    'ç', 'ÿ', 'ñ',
    'À', 'Â', 'Ä', 'Á', 'Ã', 'Å',
    'Î', 'Ï', 'Ì', 'Í', 
    'Ô', 'Ö', 'Ò', 'Ó', 'Õ', 'Ø', 
    'Ù', 'Û', 'Ü', 'Ú', 
    'É', 'È', 'Ê', 'Ë', 
    'Ç', 'Ÿ', 'Ñ', 
    ),
    array(
    'a', 'a', 'a', 'a', 'a', 'a', 
    'i', 'i', 'i', 'i', 
    'o', 'o', 'o', 'o', 'o', 'o', 
    'u', 'u', 'u', 'u', 
    'e', 'e', 'e', 'e', 
    'c', 'y', 'n', 
    'A', 'A', 'A', 'A', 'A', 'A', 
    'I', 'I', 'I', 'I', 
    'O', 'O', 'O', 'O', 'O', 'O', 
    'U', 'U', 'U', 'U', 
    'E', 'E', 'E', 'E', 
    'C', 'Y', 'N', 
    ),$var);
    return $var;
}

Code working:

$name = "Kévin";
$name = strToNoAccent($name);
$name = strtoupper($name);
echo $name; // Result is KEVIN

Code not working for unknow reason:

$chresult=mysql_query("SELECT * FROM personnel");

$y=0;
        while ($y < mysql_num_rows($chresult)) {
            $name = mysql_result($chresult, $y, 'name');

            $name = strToNoAccent($name);
            $name = strtoupper($name);
            echo $name; // Result is KÉVIN

$y++;
}

what your query is returning? put echo $name; after $name = mysql_result($chresult, $y, 'name'); — , Jan 04 '16 at 16:13

score 1 · Accepted Answer · edited May 23 '17 at 11:44

1

Looks like an encoding problem. Have you tried something with iconv ? Like :

$name = iconv('UTF-8', 'ASCII//TRANSLIT', $name);

Look at : https://stackoverflow.com/a/3542748/2761700 & How do I remove accents from characters in a PHP string?

UPDATE: also use utf8_encode. Complete code :

$chresult=mysql_query("SELECT * FROM personnel");
$y=0;
while ($y < mysql_num_rows($chresult)) {
    $name = utf8_encode(mysql_result($chresult, $y, 'name'));
    $name = iconv('UTF-8', 'ASCII//TRANSLIT', $name);
    $name = strtoupper($name);
    echo $name;
    $y++;
}

edited May 23 '17 at 11:44

Community

1
1

answered Jan 04 '16 at 16:20

scandel

1,692
3
20
39

I think it's an encoding problem too. Result with your iconv is: Notice: iconv(): Detected an illegal character in input string – BackTrack57 Jan 05 '16 at 07:16
What's the encoding of your php file ? Utf-8 ? – scandel Jan 05 '16 at 08:17
Ok. And in yout original code, can you try to enclose `$name` in utf8_encode(), like this : `$name = utf8_encode(mysql_result($chresult, $y, 'name'));` ? I have no other ideas, because I tested your exact code, and had not the same problem than you do... – scandel Jan 05 '16 at 11:02
utf8_encode makes it work ! Thank you very much. If you edit your answer with it I select "Accepted" for the answer. – BackTrack57 Jan 06 '16 at 15:29

score 0 · Answer 2 · answered Jan 04 '16 at 16:27

Tried to replicate your issue. But found the code is working absolutely fine without any of the issue

here is your code :

Function example demo : " . $name; $con = mysql_connect("localhost","root",""); $db= mysql_select_db("latin",$con); $chresult=mysql_query("SELECT * FROM personnel"); $y=0; while ($y Before conversion : " . $name; $name = strToNoAccent($name); $name = strtoupper($name); echo " After conversion : " .$name; // Result is KÉVIN $y++; } ?>

Convert accents from MySQL to no accent in a web page using PHP

2 Answers2