Device on Cyrillic error

Ivaylo3 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 Tananaev3 years ago

Your database encoding is incorrect. You need UTF.

Ivaylo3 years ago

My encoding is UTF-8

Anton Tananaev3 years ago

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

Ivaylo3 years ago

image

Anton Tananaev3 years ago

Please provide table schema.

Richard Creer3 years ago

Utf8mb4?

Ivaylo3 years ago

Anton please tell me exactly where to look?

Richard Creer3 years ago

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

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