tracker issue : CF-4199071

select a category, or use search below
(searches all categories and all time range)

CFQUERY turns Emojis into Question marks

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/Fixed

Reporter/Name(from Bugbase): Joshua Saia / Joshua Saia ()

Created: 07/14/2017

Components: Database, CFQuery

Versions: 2016,11.0,10.0,2018

Failure Type: Data Corruption

Found In Build/Fixed In Build: MySQL database 5.5.3+ / CF2016U12,CF2018U5

Priority/Frequency: Normal / All users will encounter

Locale/System: English / Mac 10 All

Vote Count: 0

Problem Description: CFQUERY turns Emojis into Question marks on insert in MySQL database

Steps to Reproduce: Using Coldfusion connected to MySQL database with everything set to use UTF8MB4 collation, try to use cfquery to insert an emoji

Actual Result: On insert, this produces question marks. If you run the query directly in MySQL workbench, the emoji inserts fine.

Expected Result: emoji should appear in table.

Any Workarounds: none



The fix for this issue will be available as part of the upcoming update of ColdFusion 2016 and 2018.  
Comment by Nimit S.
31090 | August 01, 2019 12:05:29 PM GMT