CODEWITHSUNDEEP
mysqlencodingfilenames
kostya
kostya

Reputation: 209

MySQL table file names encoding

Could someone know what encoding is used here @T0@g0@x0@y0@w0@u0@p0@[email protected] ?

This is a file name corresponding to table name which name using cyrillic letters.

Upvotes: 0

Views: 253

Answers (1)

Andrew
Andrew

Reputation: 1745

This is the MySQL internal filename encoding Documented here.

You can convert this back to normal utf8 by using a procedure like:

mysql> SELECT CONVERT(_filename'@T0@g0@x0@y0@w0@u0@p0@q0@o0' USING utf8);
+------------------------------------------------------------+
| CONVERT(_filename'@T0@g0@x0@y0@w0@u0@p0@q0@o0' USING utf8) |
+------------------------------------------------------------+
| Настройки                                                  |
+------------------------------------------------------------+
1 row in set (0.00 sec)

Upvotes: 1

Related Questions