I'm creating an application with AngularJS and PHP. In that application is a description field, which does not have a character limit. Ultimately I'm trying to save the description field with mysqli, but am having difficulty choosing a datatype.
Because there is no character limit VARCHAR doesn't work. I made the field a BLOB. I don't know how to pass the long text to mysqli if it is a BLOB, nor do I know how to read it and write it into a JSON object, or how to read it in AngularJS so that the text can be loaded back into the textarea after saving.