Incorrect string value: '\xEDa de ...' for column 'bla' at row 1

argrafic

Hello.

I developed a PHP with MySQL webpage and tested locally and in my server everything works fine.

But once the client installed it in their server when entering characters with spanish accents áéíúó and ñ they get the following error:

Incorrect string value: '\xEDa de ...' for column 'h_acontecimiento' at row 1

We both have MySQL 5 installed.

Why is that error appearing and what can I do to correct that?

Thanks!!!

NogDog

What character set does that data column use? You may need to ensure that your script is in agreement with the MySQL server as to what character set to use (example assumes UTF-8 character set):

mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET utf8");
// rest of database interaction . . .

You also may want to try to get your web pages and forms to also be in the same character set via a Content-Type header as well as an accept-charset setting in any form tags:

<?php
header('Content-Type: text/html; charset=UTF-8');
?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html lang='en'>
<head>
<meta http-equiv='Content-Type' content='text/html; charset=UTF-8'>
<title>Untitled</title>
</head>
<body>
<form action="" method="post" accept-charset="UTF-8">
</form>
</body>
</html>

judian

if you want to import a file then use this to make it fully compatible with utf8.

    $line=fixEncoding($line);
    $line=mysql_real_escape_string($line); //for making ' to \'
    $line=addcslashes($line, '%_'); //for making % to \% and _ to \_
// Fixes the encoding to utf8
    function fixEncoding($in_str) {
        $cur_encoding = mb_detect_encoding($in_str);
        if($cur_encoding == "UTF-8" && mb_check_encoding($in_str,"UTF-8")) {
            return $in_str;
        } else {
            return utf8_encode($in_str);
        }
    }