How to handle iOS emojis in sql server database?

Question

When saving smiley-faces sent from iOS phone into sql server it changes the emoji to questionmarks like this ?? instead. this normal happy face :) works fine to save in sql server db but some others dont. Anyone else done this before and maybe could help me out or put me in the right direction? Thanks alot!

score 0 · Answer 1 · answered Apr 19 '15 at 11:49

0

you can encode the string with base64Encodeing ,then insert the result into database

answered Apr 19 '15 at 11:49

cydiyo

3
2

This is a bad idea because you lose any and all abilities to search and index a column. – Dai Sep 03 '17 at 03:17

score -2 · Accepted Answer · edited May 23 '17 at 12:16

-2

Try to convert the column that contains emoji to utf8mb4 as answered in this post. https://stackoverflow.com/a/8109948/546954

edited May 23 '17 at 12:16

Community

1
1

answered Apr 19 '15 at 12:33

Shali Liu

1,174
13
23

3

This answer is for MySQL, the question is about SQL Server, there is no utf8mb4 in SQL Server – MaxiWheat Nov 03 '16 at 14:55

How to handle iOS emojis in sql server database?

2 Answers2