Hibernate Community • View topic - Large Strings truncated on persist w/ MySQL

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Large Strings truncated on persist w/ MySQL

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

ospjuth

Post subject: Large Strings truncated on persist w/ MySQL

Posted: Tue Feb 08, 2005 10:51 am

Newbie

Joined: Mon Aug 16, 2004 6:47 pm
Posts: 5

How large can a String be when persisting? I have it mapped as

<property
name="xmlDoc"
type="text"
not-null="false"
/>

BUT I can only persist/load up to size 65.535, the rest is truncated. I am using MySQL as DB. Is this a limitation of MySQL or hibernate? How can I work around it? I really would like to store large XML documents with hibernate, since I trust it is faster than an XMLDB such as Exist/Xindice. Any comments on this btw?

Thanks,

.../Ola

Top

dshk

Post subject:

Posted: Tue Feb 08, 2005 11:14 am

Beginner

Joined: Tue Feb 08, 2005 7:01 am
Posts: 21

did you notice that the mysql text type may conatin up to 65536 bytes? MEDIUMTEXT and LONGTEXT can contain longer strings

Top

ospjuth

Post subject:

Posted: Tue Feb 08, 2005 1:43 pm

Newbie

Joined: Mon Aug 16, 2004 6:47 pm
Posts: 5

Thanks. Didn't notice. Is the MEDIUMTEXT and LONGTEXT something that is special for MySQL or can I use it with all types of databases?

/Ola

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum