search

ging / fiware-draco

The Draco Generic Enabler is an alternative data persistence mechanism for managing the history of context. It is based on Apache NiFi and is a dataflow system based on the concepts of flow-based programming. It supports powerful and scalable directed graphs of data routing, transformation, and system mediation logic and also offers an intuitive graphical interface
https://fiware-draco.readthedocs.io/en/latest/
Apache License 2.0
20 stars 14 forks source link

Droco data in mysql garbled issue #54

Closed jiuaige closed 2 years ago

jiuaige commented 3 years ago

{ "type": "Room", "id": "DC_S1-D41", "temperature": { "value": "打麻将1", "type": "Number", "metadata": {} } }

This is the entity in ngsi，I listened the attr of value When the data of the table data enters mysql But there is a issue of garbled data like this: image

How can i do to solve this iesue Thank you guards,please me Or tell me your skype number And we can communicate it

anmunoz commented 3 years ago

Hi @jiuaige,

I can see that the problem shows when you use the value of the value field with some special characters. I think this is not a problem with the processor, but the configuration of the table regarding to the encoding and collation, please check the link https://stackoverflow.com/questions/9352404/mysql-with-japanese-characters. This link can provide you some clues about how you can solve it.

Best regards,