How to save special character in mysql

See more:

HTML

PHP

MySQL

web_development

Hi guys i would like to ask how do we save a special character into mysql? the situation is that i'm using tinymce for word editor. now when i type in something and put some styling in that editor its working fine when i save it in the database base. but the problem is when i type in a special character such as

<  or  > 

. when i try to view the generated word of tinymce

instead of returning < it returns "< ;"

and that how it should be. but when i try to execute the query all of the text after the special character

< ;

are gone.

I really dont know how to save it anymore... Assuming that the tinymce generated this kind of content

<span style="color: #888888;">This is the content generated by tinymce</span> and this is the special character &lt; and a greater than sign &gt;

I wish to save this content but the problem is all the character in between < and > are all erase.... how do i save this and same time retrieve and display it on tinymce? so i would like it to be display in tinymce as this

<span style="color: #888888;">This is the content generated by tinymce</span> and this is the special character < and a greater than sign >