Updating a NULL value field with some value - memory allocation?

When i insert a row in a table with a column as NULL, no memory is allocated for that. When i update the column with a value, how memory will be allocated for that column and where it will be stored?