Keep decimal null through MysqlDataWriter?

CloverDX Platform
1

Is there a way to keep a decimal null if that is a way the record comes in? It seems the MysqlDataWriter is sending 0.00 for null decimal records. In this data null and 0.00 are very different.

The metadata allows for a null on these fields and viewing the data before the MysqlDataWriter shows the data with proper null values. However, when these are written to the database, all nulls are converted to 0.00. The mysql columns are set to accept NULL values and default to null. I also tested this by doing a manual insert.

Please let me know if anyone has a suggestion.

Thanks,
Christopher

2

We are working to sort this issue. Please use a component DBOutputTable, which enables to store null values for decimal format in Mysql databases.

Ludvik