Re: Displaying or identifying emoji

2019-01-24 Thread David V Glasgow via use-livecode 
That’s fantastic! Thanks Ali, very helpful.  Awww.  ‚ù§Ô∏è is a heart!

Thanks again.

> On 24 Jan 2019, at 8:45 am, Ali Lloyd  wrote:
> 
> For the specific examples you have there, simply putting the strings through 
> textDecode(, "utf-8") will give you your emoji back.
> 
> On Wed, Jan 23, 2019 at 4:34 PM David V Glasgow via use-livecode 
> mailto:use-livecode@lists.runrev.com>> wrote:
> 
> 
> > On 23 Jan 2019, at 2:15 pm, Stephen MacLean via use-livecode 
> > mailto:use-livecode@lists.runrev.com>> 
> > wrote:
> > 
> > You say you are importing them? From where? A text file or DB?
> 
> Basically, Stephen, I take what I am given.  
> 
> Could be plain text, Word, HTML , even spreadsheetn- and often I don’t know 
> any intermediate steps between the original chat record (on whatever device 
> and in whatever software was involved), and the final format I receive.  
> Usually I get a digital record, but the last one I received was a scan of a 
> fax of a Word document.
> 
> I was hoping for easy way to back translate, gobbledegook to emoji ID/code, 
> but it looks like maybe there isn’t one.  
> 
> Thanks to all who chipped in.
> 
> Cheers,
> 
> David Glasgow
> 
> 
> 
> ___
> 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

Re: Displaying or identifying emoji

2019-01-24 Thread Ali Lloyd via use-livecode 
For the specific examples you have there, simply putting the strings
through textDecode(, "utf-8") will give you your emoji back.

On Wed, Jan 23, 2019 at 4:34 PM David V Glasgow via use-livecode <
use-livecode@lists.runrev.com> wrote:

>
>
> > On 23 Jan 2019, at 2:15 pm, Stephen MacLean via use-livecode <
> use-livecode@lists.runrev.com> wrote:
> >
> > You say you are importing them? From where? A text file or DB?
>
> Basically, Stephen, I take what I am given.
>
> Could be plain text, Word, HTML , even spreadsheetn- and often I don’t
> know any intermediate steps between the original chat record (on whatever
> device and in whatever software was involved), and the final format I
> receive.  Usually I get a digital record, but the last one I received was a
> scan of a fax of a Word document.
>
> I was hoping for easy way to back translate, gobbledegook to emoji
> ID/code, but it looks like maybe there isn’t one.
>
> Thanks to all who chipped in.
>
> Cheers,
>
> David Glasgow
>
>
>
> ___
> 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

Re: Displaying or identifying emoji

2019-01-23 Thread David V Glasgow via use-livecode 


> On 23 Jan 2019, at 2:15 pm, Stephen MacLean via use-livecode 
>  wrote:
> 
> You say you are importing them? From where? A text file or DB?

Basically, Stephen, I take what I am given.  

Could be plain text, Word, HTML , even spreadsheetn- and often I don’t know any 
intermediate steps between the original chat record (on whatever device and in 
whatever software was involved), and the final format I receive.  Usually I get 
a digital record, but the last one I received was a scan of a fax of a Word 
document.

I was hoping for easy way to back translate, gobbledegook to emoji ID/code, but 
it looks like maybe there isn’t one.  

Thanks to all who chipped in.

Cheers,

David Glasgow



___
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

Re: Displaying or identifying emoji

2019-01-23 Thread scott--- via use-livecode 
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 
>  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 
>>  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 
>>>  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

Re: Displaying or identifying emoji

2019-01-23 Thread Stephen MacLean via use-livecode 
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 
>  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 
>>  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

RE: Displaying or identifying emoji

2019-01-23 Thread Ralph DiMola via use-livecode 
"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 
>  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

Re: Displaying or identifying emoji

2019-01-23 Thread Stephen MacLean via use-livecode 
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 
>  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
> 
> 
>  
> 
>  
> 
> ___
> 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

Displaying or identifying emoji

2019-01-23 Thread David V Glasgow via use-livecode 
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


  

  
 
___
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