Using spring in mysql to access large files blob and clob

I checked some differences between clob and blob. I remember that clob is suitable for storing large text files, while blob is suitable for storing Image Binary files, it is understood as character and binary.

However, after a hands-on experiment today, we found that if a text file is not only uploaded for storage, but also needs to be downloaded and used, it is better to use blob field storage because clob storage is used, during the upload, the file format is changed according to the string operation. For example, there is no line break for the original file.

<Property name = "content" type = "org. springframework. orm. hibernate3.support. BlobByteArrayType" column = "content" length = "100000"/>

<Property name = "content" type = "org. springframework. orm. hibernate3.support. ClobStringType" column = "content" length = "100000"/>