A ColdFusion application that we developed a couple years ago worked with Twilio to log incoming text messages. The UTF-8 message payloads were saved in a MSSQL database using the NVARCHAR datatype and could be displayed on webpages without any issue. When importing a CSV file into a third-party Windows program, a random error would cause the import to abort whenever it encountered a high ASCII character. We didn't want to strip out the data, but we also didn't want to convert emojis to HTML entities or decimal values as they would be somewhat meaningless outside of an HTML environment.
That's when we discovered the email-java java library. It bills itself as the "The missing emoji library for Java" and really does add many emoji-specific features that aren't natively available in Java (or ColdFusion).
Here's a cf-email-java wrapper to help identify, sanitize and convert emojis in CFML projects. (NOTE: This my first time I creating a project in Github versus just creating a simple gist.)
For the CSV export, we used the parseToAliases method on the strings and messages like I like 🍕 were converted to I like :pizza:.
Here's some examples of functionality.
emojijava.isEmoji('❤️'); // true
emojijava.isEmoji('I ❤️ 🍕'); // false
emojijava.containsEmoji('I ❤️ 🍕'); // true
emojijava.isOnlyEmojis('I ❤️ 🍕'); // false
emojijava.isOnlyEmojis('👁 ❤️ 🍕'); // true
emojijava.parseToAliases('I like 🍕'); // I like :pizza:
emojijava.parseToHtmlDecimal('I ❤️ 🍕'); // I ❤️ 🍕
emojijava.parseToHtmlHexadecimal('I ❤️ 🍕'); // I ❤️ 🍕
emojijava.removeAllEmojis('I ❤️ 🍕'); // I
emojijava.removeAllEmojisExcept('I ❤️ 🍕', "pizza"); // I 🍕
emojijava.removeEmojis(text, "pizza"); // I ❤️
emojijava.removeEmojis('I ❤️ 🍕', "[emoji]"); // I [emoji] [emoji]
emojijava.extractEmojis('I ❤️ 🍕'); // I ["❤️", "🍕"]
emojijava.extractEmojis('I ❤️ 🍕', true); // an array of structs w/emoji data