I have a stored procedure which accepts various varchar parameters. The middle tier code which calls the procedure has not been consistent in terms of the values it submits. For example, sometimes a parameter like "Transport Description" will be submitted as NULL and sometimes it will be an empty string.
In terms of the client, an empty string simply means a value was not entered.
Should I convert all the empty varchar parameters to NULL before inserting the data?
I can't decide if this falls into the realm of a best-practice to preserve the integrity of the data or a bad idea because I'm not representing what was actually submitted to the database.
I should note that all inserts and updates are tracked in an audit log.