Special characters to mysql from php

Question

I know there have been a lot of almost the same questions, but I still didn't find the answer to my problem. I want to place "les Îles Açores" into the db. But I get:

les ÃŽles AÃ§ores

I tried usin:

SET Names 'ut8)
$mysqli->set_charset("utf8");
mysql_real_escape_string()
htmlentities (Here I got htmlentities, but I want to know if there's another way)

Code:

$name_fr = $_POST["name_fr"]; $name_nl = $_POST["name_nl"];
$arr_kollommen = array("NAME_FR","NAME_NL");
        $arr_waardes = array($naam_nl,$naam_fr);
        $obj_db->insert("landen",$arr_kollommen,$arr_waardes);

Does someone has an idea how to solve my litle problem? Thank you very much!

did you use "SET Names 'ut8)" or "SET NAMES 'utf8'". The former (as stated) is wrong — calumbrodie
– calumbrodie, Commented Nov 18, 2011 at 15:29

Anne · Accepted Answer · 2011-11-18 15:29:31Z

1

Make sure the table uses the correct CHARSET, for example:

CREATE TABLE myTable (
    one VARCHAR(255),
    two VARCHAR(255)
) DEFAULT CHARSET=utf8;

answered Nov 18, 2011 at 15:29

Anne

27.2k9 gold badges66 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user750079 Over a year ago

The fields are VARCHAR(100) and charset = utf8_general_ci

matino · Accepted Answer · 2011-11-18 15:39:07Z

1

Make sure you actually write in UTF8 (meaning your IDE / editor you write your code must have encoding set to UTF8).
Is the record corrupted both in the DB and on your page after you fetch it or only in DB?

answered Nov 18, 2011 at 15:39

matino

17.8k8 gold badges51 silver badges63 bronze badges

Comments

spreeuwtje · Accepted Answer · 2011-11-21 07:36:23Z

0

$name_fr = $_POST["name_fr"]; 
$name_nl = $_POST["name_nl"];
$arr_kollommen = array("NAME_FR","NAME_NL");
$arr_waardes = array($naam_nl,$naam_fr);
$obj_db->insert("landen",$arr_kollommen,$arr_waardes);

Try using instead of encode to utf_8 decode. like this:

$name_fr = $_POST["name_fr"]; 
$name_nl = $_POST["name_nl"];
$naam_fr = utf8_decode($naam_fr);
$naam_nl = utf8_decode($naam_nl);
$arr_kollommen = array("NAME_FR","NAME_NL");
$arr_waardes = array($naam_nl,$naam_fr);
$obj_db->insert("landen",$arr_kollommen,$arr_waardes);

answered Nov 21, 2011 at 7:36

spreeuwtje

971 silver badge7 bronze badges

Comments

Mathieu Dumoulin · Accepted Answer · 2011-11-18 15:28:40Z

0

2 possible reasons i can see:

1) Your database doesn't feature UTF-8 fields

2) When you read your data from the server, you are not setting the connection as utf-8. If you have to set it utf-8 when writting you also have to set it utf-8 when reading.

Check using PHPMyAdmin if the data is wrecked... If it is, then it means that your SET names'utf-8' is not working...

answered Nov 18, 2011 at 15:28

Mathieu Dumoulin

12.3k7 gold badges47 silver badges71 bronze badges

Comments

Ant · Accepted Answer · 2011-11-21 07:41:43Z

0

Do you pass the "UTF-8" parameter into your htmlentities, and html_entity_decode this way ?

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

answered Nov 21, 2011 at 7:41

Ant

1,8425 gold badges22 silver badges39 bronze badges

Collectives™ on Stack Overflow

Special characters to mysql from php

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related