How to specify the correct encoding for SQL in Rad Studio XE7?

Question

MySQL

Good afternoon! Two components from DbExpress are used: SqlQuery and SQLConnection
When selecting from a table, Russian letters are displayed incorrectly. It is clear that something is wrong with the encoding when transferring data. Everything in the database is stored in UTF-8. How to force to give results of request in the necessary coding?

Answer 1

If you are sure that this is the problem then try AnsiToUtf8 and Utf8ToAnsi.
But in general in XE the String type already implies UTFString. So maybe that's not the problem.