Details
-
Task
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
Description
As non-ASCII letters are encoded in database directory names and table file nasenames there should be tools that can be used to perform conversion to human-readable unicode output (and back from unicode to encoded form?), either as SQL function, command line tool, or both.
e.g. @6e2c@8a66@8cc7@6599@5eab' <-> 測試資料
See also:
- https://mariadb.com/kb/en/library/identifier-to-file-name-mapping/
- https://mariadb.com/es/resources/blog/demystifying-identifier-mapping/
and especially the comment from HeidiSQL on the later one.
Attachments
Issue Links
- relates to
-
MDEV-21825 Document mariadb-conv
- Closed
-
MDEV-21228 Document mariadb-conv
- Closed
I believe that this is a documentation issue, not a code bug.
The CONVERT function with the filename character set should already do the trick:
It will return the conversion:
@6e2c@8a66@8cc7@6599 測試資料庫
Note: these strings are from the description. The hexadecimal string had 5 encoded 5-byte characters, while the UTF-8 string only has 4 characters corresponding to the 4 first 5-byte characters.