How to transfer and show Smiley in between Android or iOS and Web (HTML)











up vote
0
down vote

favorite












I'm facing problem to show Smiley on html content where text is generated from Android or iPhone keyboard and stored in MySQL database. Right now I'm storing smiley as unicode text in database so it is converting like ud83dude01 . But there is no way to show this kind of encoded smiley in html.



I understand that not all smiley are supported in HTML code, but I want to show as much as possible like "☺" is supported so it should show, and for unsupported html smiley, "񏥠" kind of text is fine.










share|improve this question
























  • ud83dude01 is Unicode codepoints, not UTF-8. What process generated that?
    – Rick James
    Nov 4 at 21:21










  • @RickJames Thanks. I update my query. That unicode is generated from client side (Android & iPhone).
    – Yagnik Khunt
    Nov 5 at 3:56










  • Please state all the steps that the data goes through. We need to find some application code that will translate the Unicode into UTF-8.
    – Rick James
    Nov 5 at 19:24










  • You should be able to use ☺ all the way through (with a MySQL field of utf8mb4). You shouldn't need to convert to any escaped UTF-16 computer programming language syntax.
    – Tom Blodget
    Nov 6 at 11:09















up vote
0
down vote

favorite












I'm facing problem to show Smiley on html content where text is generated from Android or iPhone keyboard and stored in MySQL database. Right now I'm storing smiley as unicode text in database so it is converting like ud83dude01 . But there is no way to show this kind of encoded smiley in html.



I understand that not all smiley are supported in HTML code, but I want to show as much as possible like "☺" is supported so it should show, and for unsupported html smiley, "񏥠" kind of text is fine.










share|improve this question
























  • ud83dude01 is Unicode codepoints, not UTF-8. What process generated that?
    – Rick James
    Nov 4 at 21:21










  • @RickJames Thanks. I update my query. That unicode is generated from client side (Android & iPhone).
    – Yagnik Khunt
    Nov 5 at 3:56










  • Please state all the steps that the data goes through. We need to find some application code that will translate the Unicode into UTF-8.
    – Rick James
    Nov 5 at 19:24










  • You should be able to use ☺ all the way through (with a MySQL field of utf8mb4). You shouldn't need to convert to any escaped UTF-16 computer programming language syntax.
    – Tom Blodget
    Nov 6 at 11:09













up vote
0
down vote

favorite









up vote
0
down vote

favorite











I'm facing problem to show Smiley on html content where text is generated from Android or iPhone keyboard and stored in MySQL database. Right now I'm storing smiley as unicode text in database so it is converting like ud83dude01 . But there is no way to show this kind of encoded smiley in html.



I understand that not all smiley are supported in HTML code, but I want to show as much as possible like "☺" is supported so it should show, and for unsupported html smiley, "񏥠" kind of text is fine.










share|improve this question















I'm facing problem to show Smiley on html content where text is generated from Android or iPhone keyboard and stored in MySQL database. Right now I'm storing smiley as unicode text in database so it is converting like ud83dude01 . But there is no way to show this kind of encoded smiley in html.



I understand that not all smiley are supported in HTML code, but I want to show as much as possible like "☺" is supported so it should show, and for unsupported html smiley, "񏥠" kind of text is fine.







php mysql unicode utf-8 character-encoding






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 5 at 4:02

























asked Nov 4 at 13:18









Yagnik Khunt

12




12












  • ud83dude01 is Unicode codepoints, not UTF-8. What process generated that?
    – Rick James
    Nov 4 at 21:21










  • @RickJames Thanks. I update my query. That unicode is generated from client side (Android & iPhone).
    – Yagnik Khunt
    Nov 5 at 3:56










  • Please state all the steps that the data goes through. We need to find some application code that will translate the Unicode into UTF-8.
    – Rick James
    Nov 5 at 19:24










  • You should be able to use ☺ all the way through (with a MySQL field of utf8mb4). You shouldn't need to convert to any escaped UTF-16 computer programming language syntax.
    – Tom Blodget
    Nov 6 at 11:09


















  • ud83dude01 is Unicode codepoints, not UTF-8. What process generated that?
    – Rick James
    Nov 4 at 21:21










  • @RickJames Thanks. I update my query. That unicode is generated from client side (Android & iPhone).
    – Yagnik Khunt
    Nov 5 at 3:56










  • Please state all the steps that the data goes through. We need to find some application code that will translate the Unicode into UTF-8.
    – Rick James
    Nov 5 at 19:24










  • You should be able to use ☺ all the way through (with a MySQL field of utf8mb4). You shouldn't need to convert to any escaped UTF-16 computer programming language syntax.
    – Tom Blodget
    Nov 6 at 11:09
















ud83dude01 is Unicode codepoints, not UTF-8. What process generated that?
– Rick James
Nov 4 at 21:21




ud83dude01 is Unicode codepoints, not UTF-8. What process generated that?
– Rick James
Nov 4 at 21:21












@RickJames Thanks. I update my query. That unicode is generated from client side (Android & iPhone).
– Yagnik Khunt
Nov 5 at 3:56




@RickJames Thanks. I update my query. That unicode is generated from client side (Android & iPhone).
– Yagnik Khunt
Nov 5 at 3:56












Please state all the steps that the data goes through. We need to find some application code that will translate the Unicode into UTF-8.
– Rick James
Nov 5 at 19:24




Please state all the steps that the data goes through. We need to find some application code that will translate the Unicode into UTF-8.
– Rick James
Nov 5 at 19:24












You should be able to use ☺ all the way through (with a MySQL field of utf8mb4). You shouldn't need to convert to any escaped UTF-16 computer programming language syntax.
– Tom Blodget
Nov 6 at 11:09




You should be able to use ☺ all the way through (with a MySQL field of utf8mb4). You shouldn't need to convert to any escaped UTF-16 computer programming language syntax.
– Tom Blodget
Nov 6 at 11:09

















active

oldest

votes











Your Answer






StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














 

draft saved


draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53141248%2fhow-to-transfer-and-show-smiley-in-between-android-or-ios-and-web-html%23new-answer', 'question_page');
}
);

Post as a guest





































active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes
















 

draft saved


draft discarded



















































 


draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53141248%2fhow-to-transfer-and-show-smiley-in-between-android-or-ios-and-web-html%23new-answer', 'question_page');
}
);

Post as a guest




















































































這個網誌中的熱門文章

Tangent Lines Diagram Along Smooth Curve

Yusuf al-Mu'taman ibn Hud

Zucchini