ResultSet getDouble() check for EMPTY values

Asked Mar 12 '19 at 13:50

Active Mar 12 '19 at 13:50

Viewed 452 times

ResultSet getDouble() returns 0.0 if a value is NULL in the database. This can be checked using "ResultSet wasNull()" which returns a boolean to check if the last read value was NULL.

But, my database also holds EMPTY values? These are also converted to 0.0, and I don't find a way to check if a column has been empty.

The picture shows the result before I set the value to NULL. It is "EMPTY". So the wasNull() function does not work for my case.

This question is not about an empty result set, but rather empty values in a column.

asked Mar 12 '19 at 13:50

HideAndSeek

What's the difference between NULL and EMPTY? – Pavel Smirnov Mar 12 '19 at 13:52
@PavelSmirnov To be honest.I don't really know. It is a regular MySQL database. – HideAndSeek Mar 12 '19 at 13:53
2

What's the type of that column? If it is some text type that "empty" value might just be an empty string. – Thomas Mar 12 '19 at 13:55
1

@Thomas ah! Just found out myself aswell :D Yes, it is indeed a text column, so this is just an empty string. And I can use getString() and check for length() > 0. – HideAndSeek Mar 12 '19 at 13:56
1

It must be some type of string to be empty like this? A Double would be 0.0 or null. – Joakim Danielson Mar 12 '19 at 13:58

ResultSet getDouble() check for EMPTY values

0 Answers0