Problem while inserting special characters into mysql

Hi,

I want to insert a paragraph in one field. But everytime I insert it inserts one the part before the special characters.

I had used htmlentities ,htmlspecialchars & other functions but not able to insert the whole paragraph. But it inserts upto "How do you get started?" only after that it doesn't insert.

the insert stmt:

$sql_query = "INSERT INTO internal_mail(mem_id,message) VALUES (".$mem_id.",'".html_entity_decode($body)."'";

and the $body message to insert is:

Welcome to Mysite.

I am here to help you.

How do you get started?

• The first thing to do is to invite your friends – then when they invite their friends you will all be connected and start having fun! Click Here to invite friends

• Edit your profile – Click Here to edit your Personal, Business and Social Profile

 

Could you post the raw contents of $body ... maybe this will me see where the problem could be. It could be that you are converting entities to characters that weren't entities to start with (if that makes sense!) ...

 

what kind of field is `message`? you sure the database isn't limiting the amount of characters?

 

PM me the datatype of the 'message' column and send the complete page code you are working on, (obviously removing any passwords etc) i have a feeling that it is a character set issue...

 

Please read this if you are using MySQL: http://www.php.net/function.mysql-real-escape-string