Shows Warning

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

Help me on this

Slawek6 years ago

encoding, looking for at forum

Krishna6 years ago

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

Krishna6 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 Tananaev6 years ago

What's the encoding for the address field?

Krishna6 years ago

characterEncoding=UTF-8

Anton Tananaev6 years ago

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