Best mySQL datatype for wysiwg text editor content

TechBoyJK

Lifer
Oct 17, 2002
16,699
60
91
Hi Guys,

I'm building a simple app, and I want to let people use a WYSIWYG editor (ckeditor).

I'm trying to figure out the best possible mySQL datatype to use. I could get away with varChar, but I'm pretty sure there is better options out there. Blob? Text?
 

pdubs10

Junior Member
Apr 2, 2012
2
0
0
With mySQL you're looking at using TEXT, MEDIUMTEXT, or LONGTEXT. Those types offer out-of-row string storage with different character limits (65535, 16777215, and 4294967295, respectively).