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.

Hi Andrew Barker, 

Thanks for your solution.

I have update the MySQL side using utf8mb4 char. I think the problem is in the smarter track itself. 

I think, if i just update the connection string inside SystemSettings.xml will it work ? but actually it was encrypted like this :

<ConnectionStringEnc>encrypted string </ConnectionStringEnc>

If i don't want to update the version, will it possible ? My SmarterTrack version is still 12.x. The reason for not upgrading it, because we have a lot of customization on external providers and we have train a lot of agent about the UI. We can not afford if any integration that we have get failed for unknown reason after upgrade the version. 

Right now i have tons of email pulled from POP3 connection that was failed in Incoming spool. This is madness. 

Every single mail that was failed contains unicode chars. Every 'retry' action just resulting an error. 

If I migrate database from MySQL to MS SQL Server, will this problem get solve ?

Please tell me solution without upgrade the SmarterTrack. You can tell me any technical detail here.