Device on Cyrillic error

Ivaylo4 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 Tananaev4 years ago

Your database encoding is incorrect. You need UTF.

Ivaylo4 years ago

My encoding is UTF-8

Anton Tananaev4 years ago

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

Ivaylo4 years ago

image

Anton Tananaev4 years ago

Please provide table schema.

Richard Creer4 years ago

Utf8mb4?

Ivaylo4 years ago

Anton please tell me exactly where to look?

Richard Creer4 years ago

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

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