VARCHAR vs BLOB

Hi Experts,

Currently I'm working on an Enhancement Project where in the legacy Application we were using CLOB field to store comments.

Since CLOB is not available in MariaDb as a dataType what would be the recommended datatype to use in New System.
The max number of chars that we have for one of the such comment is 21499 chars.

What all will be the pros n cons of using VARCHAR(21499) vs BLOB datatype, and also if makes any impact on the performance of the record and UI using the comment table.

Thanks,

Gaurav Singh

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data