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.
php mysql unicode utf-8 character-encoding
add a comment |
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.
php mysql unicode utf-8 character-encoding
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
add a comment |
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.
php mysql unicode utf-8 character-encoding
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
php mysql unicode utf-8 character-encoding
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
add a comment |
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
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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