Please post. I would find this very useful. Scott Morrow
Elementary Software (Now with 20% less chalk dust!) web http://elementarysoftware.com/ email sc...@elementarysoftware.com booth 1-800-615-0867 ------------------------------------------------------ > On Jan 23, 2019, at 7:13 AM, Stephen MacLean via use-livecode > <use-livecode@lists.runrev.com> wrote: > > In my testing so far, word works while trueWord doesn’t, although that > testing is still preliminary... > > In my case, I need to strip them out. Single codepoint ones like the smiley > are easy, they are one codepoint and 1 word. The ones, like red haired man, > are tougher because they are multple codeponts. However, they are still 1 > word. > > I’ve built a sample library stack that contains all the emoji’s, their > codepoints and some routines that I’m using to work through this all. I hope > to have my testing done in the next day or two and will post for anyone who > wants to play with it. > > Best, > > Steve MacLean > >> On Jan 23, 2019, at 9:59 AM, Ralph DiMola via use-livecode >> <use-livecode@lists.runrev.com> wrote: >> >> "Also, depending on the emoji, it may be 1 codepoint or many. Use the >> keyword “word” when finding, etc." >> >> Word or "true word"? Does it matter? >> >> Ralph DiMola >> IT Director >> Evergreen Information Services >> rdim...@evergreeninfo.net >> >> -----Original Message----- >> From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf >> Of Stephen MacLean via use-livecode >> Sent: Wednesday, January 23, 2019 9:15 AM >> To: How to use LiveCode >> Cc: Stephen MacLean >> Subject: Re: Displaying or identifying emoji >> >> Hi David, >> >> Looks like you are running into some of the same issues I had when learning >> to work with them… >> >> You say you are importing them? From where? A text file or DB? >> >> Make sure that the encoding is set to UTF-8 or higher when you import. Next, >> you need to textDecode() them, again making sure that encoding matches. >> >> One MAJOR caveat that I ran into with using mySQL. After opening the >> connection, you need to add the following code to fore the connection to >> unicode: >> >> ## Set utf8mb4 >> >> revExecuteSQL tDatabaseID, "SET NAMES 'utf8mb4'" >> >> >> Or whatever your encoding is on that table. Otherwise it will default to >> ascii and you will get those characters. >> >> Also, depending on the emoji, it may be 1 codepoint or many. Use the keyword >> “word” when finding, etc. >> >> Hope this helps! >> >> Best, >> >> Steve MacLean >> >>> On Jan 23, 2019, at 7:34 AM, David V Glasgow via use-livecode >>> <use-livecode@lists.runrev.com> wrote: >>> >>> Hello folks, >>> >>> I am working on imported text messages from various sources, and which have >>> been through various (unknown) processes/displays before I get them. Some >>> retain emoji intact, but others render them as an odd series of characters >>> (presumably having been substituted when stored in a non-unicode >>> environment): >>> >>> 582 hexman555 (04/17/15 11:13:54 PM): I'll be here üòä‚ù§Ô∏è >>> 600 hexman555 (04/17/15 11:32:15 PM): Me too ‚ù§Ô∏è >>> 615 hexman555 (04/17/15 11:49:18 PM): Thank you ‚ù§Ô∏èüíã >>> 625 hexman555 (04/17/15 11:52:29 PM): ‚ù§Ô∏è‚ù§Ô∏è‚ù§Ô∏è >>> >>> I would like to know which emoji were being used, either by displaying them >>> in the field or substituting "‚ù§Ô∏è” etc with parenthetic text describing >>> the emoji. I have tried to break emojis down, but can’t find an app that >>> doesn’t display them - or rather mangles them in this way. Similarly, I >>> have looked at the ascii and hex of the component characters of the >>> gobbledegook, but can’t see a pattern. >>> >>> Any suggestions? >>> >>> >>> Best Wishes, >>> David Glasgow >>> >>> >>> <http://www.i-psych.co.uk/> <https://twitter.com/iPsychApps> >>> >>> <https://twitter.com/iPsychApps> <http://uk.linkedin.com/in/davidvglasgow> >>> <http://uk.linkedin.com/in/davidvglasgow> >>> _______________________________________________ >>> use-livecode mailing list >>> use-livecode@lists.runrev.com >>> Please visit this url to subscribe, unsubscribe and manage your >>> subscription preferences: >>> http://lists.runrev.com/mailman/listinfo/use-livecode >> >> _______________________________________________ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode >> >> >> _______________________________________________ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode