Dear all,
I have a table with the following structure.
ield Type Collation Null Key Default
Extra Privileges Comment
---------------- ------------ --------------- ------ ------ -------
-------------- ------------------------------- -------
id int(11) (NULL) NO PRI (NULL)
auto_increment select,insert,update,references
indicatorName varchar(255) utf8_general_ci YES
(NULL) select,insert,update,references
periodName varchar(255) utf8_general_ci YES
(NULL) select,insert,update,references
source varchar(255) utf8_general_ci YES
(NULL) select,insert,update,references
level int(11) (NULL) YES
(NULL) select,insert,update,references
value varchar(255) utf8_general_ci YES
(NULL) select,insert,update,references
numeratorValue varchar(255) utf8_general_ci YES
(NULL) select,insert,update,references
denominatorValue varchar(255) utf8_general_ci YES
(NULL) select,insert,update,references
The values in value,NumeratorValue and DenominatorValue
Value NumeratorValue
denominatorValue
NaN Null
