data type for text files in a database

creolophus · 06-20-2007, 09:58 PM

Hi,

I need to store text files (10K - 30K max) in an Oracle 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

paulsm4 · 06-20-2007, 11:17 PM

Yup - CLOB probably sounds like the best way to go.

You can also use a LONG.

for whatever it's worth, here's a comparison of your options:

http://www.ss64.com/orasyntax/datatypes.html