mqtt-mysql icon indicating copy to clipboard operation
mqtt-mysql copied to clipboard

​ aka ' in MySQL

Open tomasbrincil opened this issue 9 years ago • 0 comments

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!

tomasbrincil avatar Dec 18 '16 14:12 tomasbrincil