Click here to Skip to main content
14,360,151 members
Rate this:
Please Sign up or sign in to vote.
See more:
how to save emoji into the sql server and get the those emoji in asp.net c#?

What I have tried:

how to save emoji into the sql server and get the those emoji in asp.net c#?
Posted
Updated 5-Nov-19 18:50pm
Rate this:
Please Sign up or sign in to vote.

Solution 1

Here is an example: Save and Retrieve Images from the Database using ASP.NET 2.0 and ASP.NET 3.5 | DotNetCurry[^]
Note that the example is using the "image" SQL datatype, which is deprecated by now.
Use varbinary(max) instead.
   
Comments
diptyajit dey 18-Jun-17 10:58am
   
I need a How to save emoji into the SQL server and get the those emoji.
save emoji+text save the one column ..
diptyajit dey 18-Jun-17 11:03am
   
Test emoji😊 test ❤️😭😁 this my text and emoji.. i am save this value my db but emoji color not show properly please help me.
RickZeeland 18-Jun-17 11:43am
   
Aha, it seems the characters are in Unicode, maybe you can just use nvarchar() fields instead of varchar() fields.
diptyajit dey 18-Jun-17 12:54pm
   
hi i am using nvarchar() but not solve my problem.
Rate this:
Please Sign up or sign in to vote.

Solution 3

Quote:
It is better save as a Image. Once a Emoji is Selected and processed for save, convert into Image. So you could get the same.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100