79190868

Date: 2024-11-15 01:39:02
Score: 1
Natty:
Report link

Unfortunatelely we were only able to solve the issue by providing the data the correct (english formatted, decimals with . not ,) way.

Neither Node JS nor MYSQL Terminals had any problems with the data type of the column being VARCHAR(45) hereafter.

All attempts of trying to replace , vs . within a MYSQL query, or changing the data type of the field failed for reasons beyond my noobish scope.

TYVM for everyone who helped! For time constraiting reasons I have to move on, but will review in some time. TY!

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: IoT-Practitioner