I have a requirement to store an entry of Length 10000 characters. I was thinking more in lines of CLOBs, but do CLOBS work the same way as VARCHARs by not allocating the bytes unless it is really used - because this field will be empty for more than half of the records.
I will appreciate any suggestions..