MySQL longtext field

maurizio · **Joined:** Mon Jun 20, 2011 4:12 am **Posts:** 4

Hi guys,
I have a longtext field which contains some html text that in the worst case is greater than 1MB.
It's very odd, I thought that changing the Hibernate configuration from text to byte[] would have improved the performances (consider that I have to do some further string manipulation, html replace, etc.), but I was wrong.
So, I'm wondering what is the best way to configure such kind of fields?

Here is my current configuration:

Code:

FWIW I'm using Hibernate with Spring Framework.

webmaster128 · **Joined:** Mon Jun 13, 2011 4:45 am **Posts:** 1

MySQL text fields have a limit of 65,000 bytes. If you insert anything larger than that in to a normal text field mySQL will silently truncate your data without telling you. MEDIUMTEXT will store 16 million characters and LONGTEXT can handle over 4 trillion, but this information does not appear to be readily available in the online mySQL manual.

maurizio · **Joined:** Mon Jun 20, 2011 4:12 am **Posts:** 4

Many thanks for your quick reply.
Unfortunately my original question was not about the MySQL stuff, but it was rather about the right kind of java object, or even primitive type, (f.e.: byte[], String, ...) to choose in order to map with a longtext field.