Database data & emoji's

Tore Nilsen tore.nilsen at me.com
Tue Aug 14 18:24:02 EDT 2018


You should look up textEncode and textDecode in the dictionary. I think they may prove useful.

Best regards
Tore Nilsen

-------
This mail contains no viruses or bacteria as it is electronically produced and untouched by human hands. Once printed it may or may not contain various microorganisms that can cause diseases. Print and hand out at own risk. Unsolicited distribution of this mail is prohibited.







> 15. aug. 2018 kl. 00:18 skrev Stephen MacLean via use-livecode <use-livecode at lists.runrev.com>:
> 
> Hi All,
> 
> So I have data (text) stored in a mySQL DB that is set for UTF8 and it stores unicode and emoji characters just fine. 
> 
> My problem is that when I pull a field from the record set and put it into a LC field, I don’t get the unicode or emoji, just the the usual strange characters.
> 
> I know that LC fields support emoji and other unicode characters. I can cut and paste them in and they display fine.
> 
> My steps in getting the data from the DB to a LC field are:
> 
> Load the data into an array element like:
> put revDatabaseColumnNamed(sRecSet,"tw_full_text") into gCurrentRec["tw_full_text"]
> 
> Then:
> 
> put gCurrentRec["tw_full_text"] into fld "tw_full_text"
> 
> 
> I’m probably missing some encoding or decoding step along the way… can some one point me in the right direction?
> 
> Thanks,
> 
> Steve MacLean
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode




More information about the use-livecode mailing list