MYSQL TEXT datatype to string and vice versa

Question

Hi I have a table with TEXT datatype. I am using hibernate to fetch/insert data.

My problem is like

What datatype should I use in my entity class object for TEXT type?
How to convert TEXT data to string and vice versa.
Is there any alternative to TEXT datatype? I need to insert a large text(string) to this column.

user1977351 · Accepted Answer · 2014-01-22 14:54:18Z

1

Unsure of the question.
Cast string to it? I'm not sure how you have decided to retrieve the data but it should be String s = (String) textdata;
BIG TEXT or Varchar

answered Jan 22, 2014 at 14:54

user1977351

2871 gold badge2 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Arun Over a year ago

Varchar has 255 char limit.I need more. I tried to use it as a string for inserting and retrieving values. No errors are thrown ut not inserting any values into database.

user1977351 Over a year ago

Use big text then, it has a ridiculous size and it is almost the same as entering in text. Big Text is a String so converting shouldn't be needed with the proper sql code, if you would share the code you have currently that isn't working I may be able to see where the problem is.

Aniket Kulkarni · Accepted Answer · 2014-01-23 05:28:59Z

0

1.What datatype should I use in my entity class object for TEXT type?

Answer

java.lang.String

2.How to convert TEXT data to string and vice versa.

Answer

It is already String no need to convert.

3.Is there any alternative to TEXT datatype? I need to insert a large text(string) to this column.

Answer

You can store up to length 65535

hibernate mapping types

For .hbm.xml file

<property name="property" type="string">
  <column name="column" length="65535" />
</property>

You can generate .java and .hbm.xml through hibernate code generation tool for eclipse

For annotation

@Column(name = "COLUMNNAME", length = 65535)

edited Jan 23, 2014 at 5:28

answered Jan 22, 2014 at 14:44

Aniket Kulkarni

13k10 gold badges70 silver badges94 bronze badges

Collectives™ on Stack Overflow

MYSQL TEXT datatype to string and vice versa

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related