Device on Cyrillic error

Ivaylo5 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 Tananaev5 years ago

Your database encoding is incorrect. You need UTF.

Ivaylo5 years ago

My encoding is UTF-8

Anton Tananaev5 years ago

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

Ivaylo5 years ago

image

Anton Tananaev5 years ago

Please provide table schema.

Richard Creer5 years ago

Utf8mb4?

Ivaylo5 years ago

Anton please tell me exactly where to look?

Richard Creer5 years ago

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

Ivaylo5 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.