​ aka ' in MySQL
Hi there, i see some strange chars in string when i read MySQL Please have a look at "​" char which should be ' but why?
SELECT *
FROM messages
ORDER BY timestamp DESC
2016-12-18 15:36:02 ​node/1/​in/lamp/temperature 0 21.7 2016-12-18 15:36:02 ​node/1/​in/lamp/humidity 0 53.3
MQTT subscribed |node/1/lamp/lux|0|15.8333333333| MySQL INSERT INTO messages (topic_id , qos, message_id) VALUES (node/1/lamp/lux, 0, 15.8333333333) MQTT subscribed |node/1/in/air/presure|0|1144.92| MySQL INSERT INTO messages (topic_id , qos, message_id) VALUES (node/1/in/air/presure, 0, 1144.92) MQTT subscribed |node/1/in/water/temperature|0|22.062| MySQL INSERT INTO messages (topic_id , qos, message_id) VALUES (node/1/in/water/temperature, 0, 22.062)
Everything seems to be fine except writing to db? Do you have any idea what could be wrong? Thanks man!