Shows Warning

Krishna 6 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 < ...)
Krishna 6 years ago

Help me on this

Slawek 6 years ago

encoding, looking for at forum

Krishna 6 years ago

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

Krishna 6 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 Tananaev 6 years ago

What's the encoding for the address field?

Krishna 6 years ago

characterEncoding=UTF-8

Anton Tananaev 6 years ago

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