Some characters don't appear in the result of a SELECT

[Borox]

Hi,

It's not a fabrik question, but a mystery I don't explain...
Some characters which are in a database field are not shown in the result of a select.

In my database field:


My select:

$db = JFactory::getDBO();
        $sql= "SELECT destinataire_dernier_email FROM liste_utilisateur_complements where user_id = ".$user->id;
        $db->setQuery($sql);
        $db->query();
        $emails_destinataires= $db->loadResult();

The result of echo $emails_destinataires:
Martine Placette,unconseiller4,

I don't understand why my select doesn't retrieve everything...any idea?

Thanks.

 

[troester]

Try echo htmlspecialchars($emails_destinataires);

 

[Borox]

Thanks Troester, I try that and I'll let you know

 

[Borox]

Thanks Troester, you were right