not per se (as far as I am aware) but trailing nulls are just marked as such
and so take up less space and of course varchar is a variable length field
and so will be pretty minimal storage if empty.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Malek Ayadi" <m.ayadi_at_cadextan.fr> wrote in message
news:a5lhfs$sj4$1_at_reader1.imaginet.fr...
> Hi
>
> Is there any option in a database configuration allowing the reduction
> (compact) of the size of null or empty fields?
>
> Many thanks
> Malek
>
>
Received on Thu Feb 28 2002 - 09:30:00 CST
