Encoding problem

djoh

Hi,

I have been trying to fix one issue I have on my server for a long time, I now have more details about it.

I'm using post processing and my data contains plain text. It's stored in a MySQL database using InnoDB and UTF-8 encoding.
When I enter the data in the DB, I use htmlentities - hence getting " etc
Just to be sure, I also remove all the simple quotes.

When I output the data, it get stuck at "processing".

Here is the output from the server_processing:
[code]
{
"sEcho": 1,
"iTotalRecords": 2,
"iTotalDisplayRecords": 2,
"aaData": [ ['1','2010-04-06','j.vin','the IT department always need a lot of stuff','304','2010-04-08','','','','','0','','',],
['2','2010-04-07','j.vaslin','muscat

Link
En gras
entre simple quote
"entre double quote"','10050','2010-04-22','','','','','0','','',]
]
}
[/code]

The only way I found was to remove all space, symbols and /n (return).

Some links:
First discussion some times ago here: http://datatables.net/forums/comments.php?DiscussionID=911
And the "maybe" solution: http://datatables.net/forums/comments.php?DiscussionID=675

The query SET character_set_client=utf8 doesn't solve the problem.
Is something wrong with my encoding ?

Thanks in advance,
Jonathan

djoh

Finaly got it.
The \r was missing in my characters to exclude.
I'll be able to clean my database now.

I leave this post here for anybody who would face the same issue. Allan, you can delete it if this was too obvious :)