WARN: Failed to store position - Data truncation: Incorrect string value: '\xD0\x93\xD0\xB5\xD0\xBD...' for column `traccar`.`tc_positions`.`address` at row 1 - MysqlDataTruncation (... < QueryBuilder:452 < DataManager:458 < DefaultDataHandler:40 < ...)
Hi
On latest Linux Centos 8 with Mariadb I am getting above error. Does anybody familiar with this, and how to fix it?
I tried to make increase (mysql.)tc_positions.address from varchar(254) to varchar(4096). But it is still the same error.
Regards && Happy Holidays.
Dimitar
Looks like you have incorrect encoding in the database. Use UTF.
Hi Anton
Thank you for the fast answer, and your hard work.
The database was created with utf8 encoding. I have changed tc_positions.address to utf8mb4 and it is working now.
Thanks and Happy Holidays.
Dimitar
Hi
On latest Linux Centos 8 with Mariadb I am getting above error. Does anybody familiar with this, and how to fix it?
I tried to make increase (mysql.)tc_positions.address from varchar(254) to varchar(4096). But it is still the same error.
Regards && Happy Holidays.
Dimitar