How to uniquely identify an email ?

General
#1

there should be a way to identify an email ,right ?

I’ve read that is not safe as it might be left blank…

So, I want my app to check the user’s mailbox and remember what mails were opened/processed… what’s the right way to implement this ?

Thanks a lot…

#2

Store a hash of each message?

#3

That sounds good, Kem…

#4

Problem is hash function returns some characters that are no good for a varchar field…

#5

I had forgotten EncodeHex(hash, true)… It should work now… :slight_smile:

#6

The message ID is only blank for unsent mails. I use the message ID when it’s there, a hash of the message when it’s not.

#7

Instead, use EncodeBase64 - that’s more efficient (as it’ll be shorter).

#8

Thanks everybody for the feedback!

#9

One thing about Base64 is that you can’t use it where the comparison is case-insensitive since the encoding itself is case-sensitive.

#10