Re: [firebird-support] Re: Space used null values

2018-05-21 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 21-5-2018 08:09, hugo.lar...@yahoo.com [firebird-support] wrote: > I have a followup question. > If I have a varchar(1000) column with 1000 characters in it and then i > delete the value in only that column but keep the row. The row has other > columns with values. > Will the space be reclaime

[firebird-support] Re: Space used null values

2018-05-20 Thread hugo.lar...@yahoo.com [firebird-support]
Hi, I have a followup question. If I have a varchar(1000) column with 1000 characters in it and then i delete the value in only that column but keep the row. The row has other columns with values. Will the space be reclaimed and overwritten? BR, Hugo

[firebird-support] Re: Space used null values

2018-02-27 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
27.02.2018 06:42, hugo.lar...@yahoo.com [firebird-support] wrote: > > Does null values take up disk space? Yes, but much less than the declared column size. > If I have a table with 4 VARCHAR columns and I add 4 more does the table > need double space even if the new columns are null? Already