Hello,
I´m making a database to store text in. I don´t know how long sentences there will be stored in the cells and want a datatype that can handle both short words and long sentences. (100k)
Have found one type called clob that can keep up to 4 gigabyte data.
Does clob always take that amount of space or will a singel word saved in this column only take a few byte? (like varchar).
I´m using Oracle 8.0.
Thanks for any answers.
/Marcus
I´m making a database to store text in. I don´t know how long sentences there will be stored in the cells and want a datatype that can handle both short words and long sentences. (100k)
Have found one type called clob that can keep up to 4 gigabyte data.
Does clob always take that amount of space or will a singel word saved in this column only take a few byte? (like varchar).
I´m using Oracle 8.0.
Thanks for any answers.
/Marcus