Home Why some emojis in SQL Server are equal?
Reply: 1

Why some emojis in SQL Server are equal?

MhdMhd
1#
MhdMhd Published in 2018-01-10 18:38:15Z

I using SQL Server 2016 and have one database with Arabic_100_CI_AS and I inserted apple emojis to my database but some of emojis are equals in condtions but other emojis are not equal

select 1
where N'⛑' = N'✅'

or

select 1
where N'✊' = N'⭐️'

This emojis are equals:

✊ ✋ ⛑ ⭐️ ✨ ⛅️ ⛈ ⛄️ ⚽️ ⚾️ ⛳️ ⛸ ⛷ ⛹️ ⛵️ ⛴ ⛽️ ⛲️ ⛱ ⛰ ⛺ ⛪️ ⛩ ⏱ ⏲ ⏰ ⏳ ⛏ ⛓ ⛎ ❌ ⭕️ ⛔️ ❗️ ❕ ❓ ❔ ✅ ❎ ⏸ ⏯ ⏹ ⏺ ⏭ ⏮ ⏩ ⏪ ⏫ ⏬ ➕ ➖ ➗ ➰ ➿ ⬛️ ⬜️

Yogesh Sharma
2#
Yogesh Sharma Reply to 2018-01-11 04:39:16Z

As Mr. Martin Smith suggest try to collate them with help of Arabic, binary sort

select 1
where N'⛑' = N'✅' collate Arabic_BIN

or

select 1
where N'✊' = N'⭐️' collate Arabic_BIN

To answer your question : The equality of your emojis are dependent on collation.

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.305696 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO