how to declare long text column in hbm?

bhomass · **Joined:** Thu May 17, 2007 2:41 pm **Posts:** 48

I have been mapping java String to varchar(255) in mysql using

<property name="queryString" column="queryString" />
in the hbm.

Now for the first time, I need a longer data length. How do I specify that?

chucky · **Joined:** Mon Jun 12, 2006 5:33 am **Posts:** 63

Hi bhomass,

you don't have to specify the length in .hbm.xml, unless you need a fixed length. Then you could write :

Code:

chucky · **Joined:** Mon Jun 12, 2006 5:33 am **Posts:** 63

Hi bhomass,

you don't have to specify the length in .hbm.xml, unless you need a fixed length. Then you could write something like:

Code:

bhomass · **Joined:** Thu May 17, 2007 2:41 pm **Posts:** 48

that seems to have had an effect. however, the data type in mysql is now text instead of varchar(2000). is 2000 simply too big for varchar? do you know off hand the cost of using text vs. varchar?

chucky · **Joined:** Mon Jun 12, 2006 5:33 am **Posts:** 63

hi bhomass,

2000 was just an example. Use the length that you need.

davidbuzatto · **Posted:** Fri Jul 06, 2007 6:44 am

Hi!

If you are using annotations, you can use

Code:

@Column(columnDefinition="LONGTEXT")

I don´t know, but I think that may be exist a way to change de column definition when you use xmls to configure your entities.

Bye!

bhomass · **Joined:** Thu May 17, 2007 2:41 pm **Posts:** 48

I know 2000 is just an example, and I am using it as just an example. the real question is why I don't get varchar(2000).

but thanks for the tip.

TAnnison · **Joined:** Thu Dec 08, 2005 11:44 am **Posts:** 5

Because the max size for a varchar is 255?