Home Not recognize some of Emojis in sql server with Arabic_BIN collation
Reply: 0

Not recognize some of Emojis in sql server with Arabic_BIN collation

user740
1#
user740 Published in April 24, 2018, 10:31 am

I'm using SQL Server 2016 and my database has the Arabic_100_CI_AS collation. I inserted apple emojis in my database, but some of the emojis are equal in comparisons while other emojis are not equal. I resolved this problem with collate Arabic_BIN and I asked in this topic

But I have new problem with Arabic_BIN Collation: For example I can't recognize some of emojis with this query:

SELECT [EMoji_ID]
FROM [Emojies].[dbo].[Emojies]
WHERE Emoji_Emoji = N'❤' COLLATE Arabic_BIN

The above query returns any ID, but this query returns ID:

SELECT [EMoji_ID]
FROM [Emojies].[dbo].[Emojies]
WHERE Emoji_Emoji = N'❤'
You need to login account before you can post.

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

© 2016 Powered by mzan.com design MATCHINFO