You are right Rod, this is only happen in mysql. I did some changes with sql queries. I was able to inject emoji unicode character directly to mysql database using query. Database side was done correctly, but the problem right now is in the application side (ST). I think i need that custom build, So every ticket creation from POP importing, API web services, portal, Adding message to ticket, reply the ticket, displaying the ticket, everything should support this unicode char. Including subject and body-text.
So, if i can stay in version 12 with custom build i would be happy instead of upgrade it to v13. Should i purchase a support ticket or you can help me with another solution ?
I saw connection string was encrypted in SystemSettings.xml, is it enough to just specify charset through connection string to support utf8mb4 or you need to recompile the whole of ST program ?