Please help me(Database)

I have learned database a little.Using MySQL I can create own database of tables.But I want to store a .txt file or a paragraph in my database.How can I solved it?

I have read about text datatype but I can't use that.
Anyone please help me..
Thanks in advance.

Try using a Blob field. I currently use it for storing images in a MySQL database.

And why are you asking this on a Java forum?

That aside, why can't you use text? Large text is what it was designed for.
Failing that, a VARCHAR(max) may be good enough, if you're 5+ and need fewer than 65k characters.

Quote:

---

Originally Posted by Tolls

And why are you asking this on a Java forum?

That aside, why can't you use text? Large text is what it was designed for.
Failing that, a VARCHAR(max) may be good enough, if you're 5+ and need fewer than 65k characters.

---

Well, I am potty trained an I use Clobs for large texts (not Blobs)

kind regards,

Jos ;-)

Does MySQL have CLOBs?
I thought it was BLOBs and TEXT?

...oh and :p to the 5+ joke...:)

Quote:

---

Originally Posted by Tolls

Does MySQL have CLOBs?
I thought it was BLOBs and TEXT?

---

Yup, they call them TINYTEXT, TEXT, MEDIUMTEXT or LONGTEXT for reasons that are beyond me (don't you love those SQL standards?)

kind regards,

Jos

Life would be too easy otherwise.

Actually I want to know that What is the statement to create that text table in database?
example:
create table(mn varchar(100));


For text what will be the statement?

Let me google that for you

Quote:

---

Originally Posted by UJJAL DHAR

Actually I want to know that What is the statement to create that text table in database?
example:
create table(mn varchar(100));


For text what will be the statement?

---

Strange, because in your OP you wrote this:

Quote:

---

Using MySQL I can create own database of tables.

---

It doesn't take rocket science to change the type of one of the columns to clob, text or whatever ...

kind regards,

Jos