Shows Warning

Krishna5 years ago
2019-08-11 18:03:13  WARN: Failed to store position - Incorrect string value: '\xC5\xAAs\xC5\xABr...' for column 'address' at row 1 - SQLException (... < QueryBuilder:480 < DataManager:458 < DefaultDataHandler:40 < ...)
Krishna5 years ago

Help me on this

Slawek5 years ago

encoding, looking for at forum

Krishna5 years ago

Hello Anton,
In encoding everything looks fine, still it continues to show warning.

Krishna5 years ago
<entry key='database.url'>jdbc:mysql://localhost:3306/traccar?useSSL=false&amp;allowMultiQueries=true&amp;autoReconnect=true&amp;useUnicode=yes&amp;characterEncoding=UTF-8&amp;sessionVariables=sql_mode=''</entry>
Anton Tananaev5 years ago

What's the encoding for the address field?

Krishna5 years ago

characterEncoding=UTF-8

Anton Tananaev5 years ago

That's not column encoding. That's database connection encoding. I would recommend you to study MySQL documentation.