D
D
David It2022-03-28 04:50:11
MariaDB
David It, 2022-03-28 04:50:11

How to solve the problem in working with mariadb?

Hello. Decided to try to work with mariadb. And while filling the table, I encountered the following error:

MariaDB [students]> CREATE TABLE department(
    -> department_id INT PRIMARY KEY AUTO_INCREMENT, 
    -> name_department VARCHAR(30));
Query OK, 0 rows affected (0.033 sec)

MariaDB [students]> INSERT INTO department (department_id,name_department) 
    -> VALUES (1,'Инженерная школа'),
    -> (2,'Школа естественных наук');
ERROR 1366 (22007): Incorrect string value: '\xD0\x98\xD0\xBD\xD0\xB6...' for column `students`.`department`.`name_department` at row 1

How to solve it? They say that there may be a problem with the encoding. but how to change it and for what?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question