Keep decimal null through MysqlDataWriter?

edhcrjones

• August 16, 2011 00:00

• Answered

Follow

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

• 

  lvalicek

  • August 22, 2011 12:40

  0

  Comment actions Permalink

  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

Please sign in to leave a comment.