I have noticed that when UseUnicode is enabled, MyDAC sends this command to server right after starting its connection:
Code: Select all
SET NAMES 'utf8'
utf8mb4 is a much better alternative, since unlike its predecessor it is standards-compliant. It is also a requirement if you want to use some of the newer collations (such as utf8mb4_0900_ai_ci).
It's fairly simple for the application developer to override MyDAC SET NAMES string by sending a new one afterwards, e.g.
Code: Select all
MyConnection1.ExecSQL('SET NAMES utf8mb4');
Would be great if the MyDAC developers could confirm if utf8mb4 can be used or -even better!- upgrade the SET NAMES string in MyDAC.