如何将内容段转换为存储在mysql中？

Question

I am using Bootstrap Summernote in form. I insert the data via Jquery-Ajax in php. Now i have one paragraph which i am entering in Summernote Editor. Which i want to convert the special characters which is entered in Editor.

Editor Content Like Below :

“Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc ac ullamcorper enim. Nam consectetur aliquam consequat. Quisque in odio in lorem porta vehicula et eget quam”

Vivamus ornare ante vel tincidunt efficitur. Ut et semper diam, non aliquet elit. Nunc vulputate gravida magna. Vivamus malesuada, nisl ac placerat ultricies - purus ligula venenatis neque, et tristique massa urna id risus. Nam laoreet, dui ut congue elementum, sapien lectus congue tortor, a aliquam lorem sapien mattis arcu. Mauris dapibus lorem eleifend lacus euismod faucibus. Nullam congue, dolor nec tempor feugiat, quam ligula congue lacus, sit amet aliquet orci velit id turpis.

How should i encode this text to store in the database and decode for view in html page as same as paragraph? My concern is how to encode-decode special character in php-mysql?

Answer 1

In MySQL you have TEXT and BLOB types which are used for storing big amount of data.

The difference with VARCHAR is that those are stored off the table in some external location and are just referred to by a pointer from the record. Hence they are slower than VARCHAR but with the plus side of allowing you to store more data. The mentioned types can contain data with max length 2^16 byte. If you need to store more data you have LONGBLOB, LONGTEXT that go up to 2^32.