| Data type for medium size text files [message #246425] |
Wed, 20 June 2007 20:28  |
creolophus
Messages: 1
Registered: June 2007
|
Junior Member |
|
|
Hi,
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
Thanks
|
|
|
|
| Re: Data type for medium size text files [message #246494 is a reply to message #246425] |
Thu, 21 June 2007 01:54  |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
