Hi Bill.  This ability is coming very soon to SmarterTrack.  It's currently possible, but it does involve a custom build along with running some SQL queries.  And this is only when using mySQL.  I believe SQL Server already supports this.

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 ?

 

thanks

 

Hi Bill.  This is that custom build for SmarterTrack 12.  Uninstall your current version of SmarterTrack 12, and then install this version.

 

If it's still not working after installing this, let me know and I'll send you the SQL queries I ran to get this to work.  These SQL queries will convert all required tables to utf8mb4.

Hi Rod, i have tried to install your custom build, but it is seems the problem still there.

I got error on Diagnostic 

Incorrect string value: '\xF0\x9F\x99\x8F</...' for column 'BodyHtml' at row 1

 

SmarterTrack 14.x fully supports emoji characters when used with a MySQL database. If you are upgrading from a previous version of SmarterTrack, the MySQL database will be modified to use UTF8MB4 character encoding instead of UTF8.