Running the following SQL code (under windows10):

USE books; INSERT INTO Customers VALUES (1, 'Иван Петров', 'бул. Гудвина, 12', 'г. Изумрудный'), (2, 'Петр Сидоров', 'ул. Незнайки, 34', 'г. Солнечный'), (3, 'Сидор Иванов', 'пер. Поттера, 56', 'п.г.т. Хогвартс');

In the table, instead of Cyrillic characters, question marks of the form ????????? (not that encoding) fall into the table. What encoding to set? cp1251 not working.

  • Most likely, you do not have the correct database encoding, or, when connecting to the database, you do not specify the encoding that you intend to use for the data. Ie, if by default you have a UTF-8 DB encoding for example, when connecting you do not specify an encoding from the same terminal or code, but it is in windows-1251, then the Cyrillic characters will not understand you, but Latin will understand it, therefore? ?????. - Nik Horse
  • @NikPashchuk How to change MySQL encoding? - Anton

0