Issue with NULL data in column
Good Day, using Arduino MySQL Connector ver 1.0.4 on Adafruit ESP8266 HUZAH. Data table set up with 12 columns, several which allow NULL's. Code is based upon the 'Basic Select Example'. When data returned contains NULL data in a column I get unexpected result shown below:
Running SELECT and printing results
SELECT TimeBased, collFrequency, collDuration, A_Time_HR, A_Time_MIN, B_Time_HR, B_Time_MIN, C_Time_HR, C_Time_MIN, CycleSync FROM mqttData.deviceParms WHERE devID = '1234'
1,3600,25,16,0,00û1m!3600,Time_HR, B_Time_MIN, C_Time_HR, C_Time_MIN, CycleSync FROM mqttData.deviceParms WHERE devID = ',234',ÿ?Äÿ?¼ ,?ä ÿ?$ ÿ?d ÿ?¤ ÿ?ä ÿ?$
ÿ?
If I populate null fields, I get data as expected shown below:
Running SELECT and printing results
SELECT TimeBased, collFrequency, collDuration, A_Time_HR, A_Time_MIN, B_Time_HR, B_Time_MIN, C_Time_HR, C_Time_MIN, CycleSync FROM mqttData.deviceParms WHERE devID = '1234'
1,3600,25,16,0,0,0,0,0,1
Is this behavior expected?
Thank you.