CODEWITHSUNDEEP
mysqlhtmleditorcharacter
Andres
Andres

Reputation: 2023

How to store html characters in mysql and display them correctly

Not sure if I am asking this correctly. But I am using a Jquery HTML Editor cleditor so that the users can load html text. When I insert this into my db(mysql) and want to display the outcome it takes out any html characters it had like: <p>, <span>, and so on. So when I go view it, it shows like this: 

class=\"noticia_texto\">jlasdfklsfklaf

which obviously it's not readable. Help please? Should I be using anything at the time of inserting or displaying or both? Also my datatype is set to Blob.

Upvotes: 0

Views: 845

Answers (1)

Marc B
Marc B

Reputation: 360612

MySQL does NOT strip html tags. If they're being removed upon insertion (or retrieval), then it's something in your code doing it, not MySQL.

Given that the quotes in your snippet are escaped, you've almost certainly got magic_quotes enabled, and/or a home-brew SQL escaping function run amok.

Upvotes: 1

Related Questions