Home » Developer & Programmer » Designer » Data type for medium size text files
Data type for medium size text files [message #246425] Wed, 20 June 2007 20:28 Go to next message
Messages: 1
Registered: June 2007
Junior Member

I need to store text files (10K - 30K max) in a database for a light-weight content-management-system.

(I know I don't need a database for that, but I want to experiment!)

Which data type would be best ? I think CLOB would do fine, but is it the only option?

I mean, MySQL has types like mediumtext, etc. Is there anything like that?

And, I use (or my college uses) version 9i

Re: Data type for medium size text files [message #246494 is a reply to message #246425] Thu, 21 June 2007 01:54 Go to previous message
Messages: 21678
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
My first thought was a CLOB as well.

You could use LONG (VARCHAR2's big brother), but it is deprecated. Also, there is XMLtype (which is to be populated with XML from a CLOB or VARCHAR2).

A conclusion? Stay with CLOB.
Previous Topic: Designer for Windows Vista
Next Topic: Design decision - Table partitioning for archiving?
Goto Forum:

Current Time: Wed Jun 23 17:15:21 CDT 2021