1

I have sql table, where there is a field

first_name varchar(255) NOT NULL DEFAULT

And i have "'Р˜РіРѕСЂСЊ'", who can help to convert to readable text?

Ergest Basha
  • 7,870
  • 4
  • 8
  • 28
Maxim
  • 39
  • 2
  • 1
    Execute: `SHOW CREATE TABLE tablename;` and `SHOW VARIABLES LIKE 'char%';` and `SHOW VARIABLES LIKE 'coll%';`, add outputs to the question. – Akina Dec 30 '21 at 06:50
  • Does this answer of your question https://stackoverflow.com/questions/4316290/mysql-russian-characters-display-incorectly – Faheem azaz Bhanej Dec 30 '21 at 08:16

1 Answers1

2

You may need to change collation of your table The collation effects to string comparing/sorting only. to Cyrillic_General_CI_AS.

Default SQL Collation depends on Language

Changsong Li
  • 143
  • 6
  • *You may need to change collation of your table* The collation effects to string comparing/sorting only. *to `Cyrillic_General_CI_AS`.* This collation can be not available due to charset setting. – Akina Dec 30 '21 at 07:28