Had a chat to our resident dba's, they came up with a solution.

In the code that extracts the data, you just need to replace the NULL's with a NULL, see...