Device on Cyrillic error

Ivaylo 5 years ago

Hello.
I have installed the latest version of the tracccar server.
My problem is when I try to add a new device and set its name to be in Cyrillic then I get this error:

Incorrect string value: '\xD0\xB5\xD0\xB5\xD0\xB5' for column 'name' at row 1 - SQLException (... < QueryBuilder:452 < DataManager:464 < BaseObjectManager:137 < ...)

How do I fix this?

Anton Tananaev 5 years ago

Your database encoding is incorrect. You need UTF.

Ivaylo 5 years ago

My encoding is UTF-8

Anton Tananaev 5 years ago

Please provide some proof. Like "show create table ..." output.

Ivaylo 5 years ago

image

Anton Tananaev 5 years ago

Please provide table schema.

Richard Creer 5 years ago

Utf8mb4?

Ivaylo 5 years ago

Anton please tell me exactly where to look?

Richard Creer 5 years ago

If your database is mysql try setting the character set of tc_devices to utf8mb4

Ivaylo 5 years ago

I install spep by step from this in server digitalocean.
I did everything as written and my server works perfectly. I don't know what exactly I have to do to fix this problem.
If someone can guide me step by step I will be very grateful.
I have no problems with the Cyrillic on the site only when I write the name of a new device then it appears.