Dear Developpers,

Fisrt of all I thank you for this great product that is saving my life.

I have a problem for the coding of the characters.

When I creat a table using wpDataTables, the text in French is imported integrally with the accents like (à, é,ç,è...). 

The display of those text using wpDataTables is ok but if I retreive those text from the database using mysql_query the characters with accent appear wrongly like bellow. I use all sort of UTF-8 converters but no result.

Nontiss�s, m�me impr�gn�s, enduits, recouverts ou stratifi�s.

My questions are:

1- Is there any way to convert the text to HTML format before it goes to the database like comming from an INPUT?

2- Or, is there a script to convert the texte to HTML format after retrieving it from the database?

3- How can you assist me to solve that issue?

Thank you.

Dear Jovanovic,

Thank you for your quick reply.

The display using wpDataTables is perfect.

The problem is this:  I want to display a particular data in my page. 

When I retreive those text from the database using mysql_query the characters with accent appear wrongly.

$sel ="SELECT id, note FROM tableau where id = 5";

$t = mysql_query($sel,$cn) or die(mysql_error());

while($res = mysql_fetch_assoc($t)){

echo $res['note'];

}

The result is 

Nontiss�s, m�me impr�gn�s, enduits, recouverts ou stratifi�s.

But if I display the whole table using wpDataTables everything is perfect.

That is my issue.

Thank you.

Dear Jovanovic,

My question is:

Is there any way I can create a table using wpDataTables where the data from the data source is converted to HTML format before going to the table. 

For example the character è is converted to è à converted to à.....

So that the browser can display it when it's retreived using any application.

That is the main of my preocupation please.

Thank you.

Paul