UTF-8: showing correct in database, but not in webpageImporting CSV file to MySQL via PHPMyAdminTell MySQL to...
Why does 0.-5 evaluate to -5?
RS485 using USART or UART port on STM32
How to not let the Identify spell spoil everything?
Buying a "Used" Router
How much light is too much?
Is it possible to rotate the Isolines on a Surface Using `MeshFunction`?
Democratic Socialism vs Social Democracy
Case protection with emphasis in biblatex
Writing dialogues for characters whose first language is not English
How do I add a strong "onion flavor" to the biryani (in restaurant style)?
How do you get out of your own psychology to write characters?
Should a new user just default to LinearModelFit (vs Fit)
How to change a .eps figure to standalone class?
XOR-free sets: Maximum density?
What are some ways of extending a description of a scenery?
What does からか mean?
What does an unprocessed RAW file look like?
If I tried and failed to start my own business, how do I apply for a job without job experience?
Eww, those bytes are gross
why typing a variable (or expression) prints the value to stdout?
Is the percentage symbol a constant?
What is the draw frequency for 3 consecutive games (same players; amateur level)?
Count repetitions of an array
How can I handle players killing my NPC outside of combat?
UTF-8: showing correct in database, but not in webpage
Importing CSV file to MySQL via PHPMyAdminTell MySQL to start using utf-8 encoding without `convert to`ing itMySQL database drop insanely slowWhy are there different levels of MySQL collation/charsets?MySQL silently replaces UTF chars with literal question marksMysql Optimization suggessionsmysqldump shows pairs of utf8 chars when dumping a utf8 databaseGerman umlaute represented by questionmarks when latin1 is usedExporting an Excel Spreadsheet containing a pivot table and charts to MySQLHow to debug difference in command line and work bench out put for MySQL?
When i upload data from php post forums "हिन्दी" language, changed into "हरिà" in database but looking correct in webpage,
and
when i upload data through phpmyAdmin from csv file "हिन्दी" changed into "???????" in webpage but looking correct in mysql database,
i ran a query,
SHOW VARIABLES LIKE '%char%'
output results:
+------------------------------+-------+--+----+--+----+--+---
| Variable_name | Value |
+------------------------------+-------+--+----+--+----+--+---
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| | |
| character_set_database | utf8mb4 |
|
| character_set_filesystem | binary |
| | |
| character_set_results | utf8mb4 |
| | |
| character_set_server | latin1 |
| character_set_system | utf8 |
|
| character_sets_dir | /usr/share/mysql/charsets/ |
| +------------------------------+-------+--+----+--+----+--
is everything ok?
i have thousands of data, so i don't want to upload from post forums one bye one.
how to get correct this, to get expected results?
MySQL version 5.6.37
mysql phpmyadmin encoding utf-8
asked Dec 3 '17 at 11:53
Praveen YadavPraveen Yadav
12
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
When i upload data from php post forums "हिन्दी" language, changed into "हरिà" in database but looking correct in webpage,
and
when i upload data through phpmyAdmin from csv file "हिन्दी" changed into "???????" in webpage but looking correct in mysql database,
i ran a query,
SHOW VARIABLES LIKE '%char%'
output results:
+------------------------------+-------+--+----+--+----+--+---
| Variable_name | Value |
+------------------------------+-------+--+----+--+----+--+---
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| | |
| character_set_database | utf8mb4 |
|
| character_set_filesystem | binary |
| | |
| character_set_results | utf8mb4 |
| | |
| character_set_server | latin1 |
| character_set_system | utf8 |
|
| character_sets_dir | /usr/share/mysql/charsets/ |
| +------------------------------+-------+--+----+--+----+--
is everything ok?
i have thousands of data, so i don't want to upload from post forums one bye one.
how to get correct this, to get expected results?
MySQL version 5.6.37
mysql phpmyadmin encoding utf-8
asked Dec 3 '17 at 11:53
Praveen YadavPraveen Yadav
12
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
When i upload data from php post forums "हिन्दी" language, changed into "हरिà" in database but looking correct in webpage,
and
when i upload data through phpmyAdmin from csv file "हिन्दी" changed into "???????" in webpage but looking correct in mysql database,
i ran a query,
SHOW VARIABLES LIKE '%char%'
output results:
+------------------------------+-------+--+----+--+----+--+---
| Variable_name | Value |
+------------------------------+-------+--+----+--+----+--+---
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| | |
| character_set_database | utf8mb4 |
|
| character_set_filesystem | binary |
| | |
| character_set_results | utf8mb4 |
| | |
| character_set_server | latin1 |
| character_set_system | utf8 |
|
| character_sets_dir | /usr/share/mysql/charsets/ |
| +------------------------------+-------+--+----+--+----+--
is everything ok?
i have thousands of data, so i don't want to upload from post forums one bye one.
how to get correct this, to get expected results?
MySQL version 5.6.37
mysql phpmyadmin encoding utf-8
asked Dec 3 '17 at 11:53
Praveen YadavPraveen Yadav
12
When i upload data from php post forums "हिन्दी" language, changed into "हरिà" in database but looking correct in webpage,
and
when i upload data through phpmyAdmin from csv file "हिन्दी" changed into "???????" in webpage but looking correct in mysql database,
i ran a query,
SHOW VARIABLES LIKE '%char%'
output results:
+------------------------------+-------+--+----+--+----+--+---
| Variable_name | Value |
+------------------------------+-------+--+----+--+----+--+---
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| | |
| character_set_database | utf8mb4 |
|
| character_set_filesystem | binary |
| | |
| character_set_results | utf8mb4 |
| | |
| character_set_server | latin1 |
| character_set_system | utf8 |
|
| character_sets_dir | /usr/share/mysql/charsets/ |
| +------------------------------+-------+--+----+--+----+--
is everything ok?
i have thousands of data, so i don't want to upload from post forums one bye one.
how to get correct this, to get expected results?
MySQL version 5.6.37
mysql phpmyadmin encoding utf-8
mysql phpmyadmin encoding utf-8
asked Dec 3 '17 at 11:53
Praveen YadavPraveen Yadav
12
asked Dec 3 '17 at 11:53
Praveen YadavPraveen Yadav
12
edited Dec 3 '17 at 17:53
Praveen Yadav
asked Dec 3 '17 at 11:53
Praveen YadavPraveen Yadav
12
asked Dec 3 '17 at 11:53
Praveen YadavPraveen Yadav
12
asked Dec 3 '17 at 11:53
Praveen YadavPraveen Yadav
12
12
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Two different errors "Mojibake" and "Question marks". Both are discussed in https://stackoverflow.com/questions/38363566/trouble-with-utf8-characters-what-i-see-is-not-what-i-stored
You have the equivalent of SET NAMES utf8mb4, but that is only one thing. Are the bytes in the csv file really UTF-8? Are the column(s) defined as CHARACTER SET utf8mb4? Does the <form...> indicate utf8 is expected? Etc. (See that link.)
Dump the hex from the table; it should be E0A4B9 E0A4BF E0A4A8 E0A58D E0A4A6 E0A580 for those letters and signs. C3A0 C2A4 ... would indicate "double encoding". I point out the hex because your statement 'changed into "हरिà" in database but looking correct in webpage' could be caused by either Mojibake or double encoding -- depending on whether the coding problem is with inserting or with selecting.
Note: CHARACTER SET utf8 and ut8mb4 are both adequate for Devangari and other Indian languages. It is better to stick with utf8mb4 in case you ever need Emoji or Chinese.
answered Dec 3 '17 at 17:08
Rick JamesRick James
42.9k22259
bytes in the csv file is UTF-8,columns defined as CHARACTER SET utf8mb4,table defined as CHARACTER SET utf8mb4
– Praveen Yadav
Dec 3 '17 at 17:52
And the settings for phpmyadmin?
– Rick James
Dec 3 '17 at 20:02
And the<meta ...in the html?
– Rick James
Dec 3 '17 at 20:03
And the hex of the data in the table?
– Rick James
Dec 3 '17 at 20:03
yes i have a meta tag,<meta charset="UTF-8">in my html,
– Praveen Yadav
Dec 3 '17 at 20:09
|
show 10 more comments
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
});
}
});
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f192274%2futf-8-showing-correct-in-database-but-not-in-webpage%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Two different errors "Mojibake" and "Question marks". Both are discussed in https://stackoverflow.com/questions/38363566/trouble-with-utf8-characters-what-i-see-is-not-what-i-stored
You have the equivalent of SET NAMES utf8mb4, but that is only one thing. Are the bytes in the csv file really UTF-8? Are the column(s) defined as CHARACTER SET utf8mb4? Does the <form...> indicate utf8 is expected? Etc. (See that link.)
Dump the hex from the table; it should be E0A4B9 E0A4BF E0A4A8 E0A58D E0A4A6 E0A580 for those letters and signs. C3A0 C2A4 ... would indicate "double encoding". I point out the hex because your statement 'changed into "हरिà" in database but looking correct in webpage' could be caused by either Mojibake or double encoding -- depending on whether the coding problem is with inserting or with selecting.
Note: CHARACTER SET utf8 and ut8mb4 are both adequate for Devangari and other Indian languages. It is better to stick with utf8mb4 in case you ever need Emoji or Chinese.
answered Dec 3 '17 at 17:08
Rick JamesRick James
42.9k22259
bytes in the csv file is UTF-8,columns defined as CHARACTER SET utf8mb4,table defined as CHARACTER SET utf8mb4
– Praveen Yadav
Dec 3 '17 at 17:52
And the settings for phpmyadmin?
– Rick James
Dec 3 '17 at 20:02
And the<meta ...in the html?
– Rick James
Dec 3 '17 at 20:03
And the hex of the data in the table?
– Rick James
Dec 3 '17 at 20:03
yes i have a meta tag,<meta charset="UTF-8">in my html,
– Praveen Yadav
Dec 3 '17 at 20:09
|
show 10 more comments
Two different errors "Mojibake" and "Question marks". Both are discussed in https://stackoverflow.com/questions/38363566/trouble-with-utf8-characters-what-i-see-is-not-what-i-stored
You have the equivalent of SET NAMES utf8mb4, but that is only one thing. Are the bytes in the csv file really UTF-8? Are the column(s) defined as CHARACTER SET utf8mb4? Does the <form...> indicate utf8 is expected? Etc. (See that link.)
Dump the hex from the table; it should be E0A4B9 E0A4BF E0A4A8 E0A58D E0A4A6 E0A580 for those letters and signs. C3A0 C2A4 ... would indicate "double encoding". I point out the hex because your statement 'changed into "हरिà" in database but looking correct in webpage' could be caused by either Mojibake or double encoding -- depending on whether the coding problem is with inserting or with selecting.
Note: CHARACTER SET utf8 and ut8mb4 are both adequate for Devangari and other Indian languages. It is better to stick with utf8mb4 in case you ever need Emoji or Chinese.
answered Dec 3 '17 at 17:08
Rick JamesRick James
42.9k22259
bytes in the csv file is UTF-8,columns defined as CHARACTER SET utf8mb4,table defined as CHARACTER SET utf8mb4
– Praveen Yadav
Dec 3 '17 at 17:52
And the settings for phpmyadmin?
– Rick James
Dec 3 '17 at 20:02
And the<meta ...in the html?
– Rick James
Dec 3 '17 at 20:03
And the hex of the data in the table?
– Rick James
Dec 3 '17 at 20:03
yes i have a meta tag,<meta charset="UTF-8">in my html,
– Praveen Yadav
Dec 3 '17 at 20:09
|
show 10 more comments
Two different errors "Mojibake" and "Question marks". Both are discussed in https://stackoverflow.com/questions/38363566/trouble-with-utf8-characters-what-i-see-is-not-what-i-stored
You have the equivalent of SET NAMES utf8mb4, but that is only one thing. Are the bytes in the csv file really UTF-8? Are the column(s) defined as CHARACTER SET utf8mb4? Does the <form...> indicate utf8 is expected? Etc. (See that link.)
Dump the hex from the table; it should be E0A4B9 E0A4BF E0A4A8 E0A58D E0A4A6 E0A580 for those letters and signs. C3A0 C2A4 ... would indicate "double encoding". I point out the hex because your statement 'changed into "हरिà" in database but looking correct in webpage' could be caused by either Mojibake or double encoding -- depending on whether the coding problem is with inserting or with selecting.
Note: CHARACTER SET utf8 and ut8mb4 are both adequate for Devangari and other Indian languages. It is better to stick with utf8mb4 in case you ever need Emoji or Chinese.
answered Dec 3 '17 at 17:08
Rick JamesRick James
42.9k22259
Two different errors "Mojibake" and "Question marks". Both are discussed in https://stackoverflow.com/questions/38363566/trouble-with-utf8-characters-what-i-see-is-not-what-i-stored
You have the equivalent of SET NAMES utf8mb4, but that is only one thing. Are the bytes in the csv file really UTF-8? Are the column(s) defined as CHARACTER SET utf8mb4? Does the <form...> indicate utf8 is expected? Etc. (See that link.)
Dump the hex from the table; it should be E0A4B9 E0A4BF E0A4A8 E0A58D E0A4A6 E0A580 for those letters and signs. C3A0 C2A4 ... would indicate "double encoding". I point out the hex because your statement 'changed into "हरिà" in database but looking correct in webpage' could be caused by either Mojibake or double encoding -- depending on whether the coding problem is with inserting or with selecting.
Note: CHARACTER SET utf8 and ut8mb4 are both adequate for Devangari and other Indian languages. It is better to stick with utf8mb4 in case you ever need Emoji or Chinese.
answered Dec 3 '17 at 17:08
Rick JamesRick James
42.9k22259
answered Dec 3 '17 at 17:08
Rick JamesRick James
42.9k22259
answered Dec 3 '17 at 17:08
Rick JamesRick James
42.9k22259
answered Dec 3 '17 at 17:08
Rick JamesRick James
42.9k22259
42.9k22259
bytes in the csv file is UTF-8,columns defined as CHARACTER SET utf8mb4,table defined as CHARACTER SET utf8mb4
– Praveen Yadav
Dec 3 '17 at 17:52
And the settings for phpmyadmin?
– Rick James
Dec 3 '17 at 20:02
And the<meta ...in the html?
– Rick James
Dec 3 '17 at 20:03
And the hex of the data in the table?
– Rick James
Dec 3 '17 at 20:03
yes i have a meta tag,<meta charset="UTF-8">in my html,
– Praveen Yadav
Dec 3 '17 at 20:09
|
show 10 more comments
bytes in the csv file is UTF-8,columns defined as CHARACTER SET utf8mb4,table defined as CHARACTER SET utf8mb4
– Praveen Yadav
Dec 3 '17 at 17:52
And the settings for phpmyadmin?
– Rick James
Dec 3 '17 at 20:02
And the<meta ...in the html?
– Rick James
Dec 3 '17 at 20:03
And the hex of the data in the table?
– Rick James
Dec 3 '17 at 20:03
yes i have a meta tag,<meta charset="UTF-8">in my html,
– Praveen Yadav
Dec 3 '17 at 20:09
bytes in the csv file is UTF-8,columns defined as CHARACTER SET utf8mb4,table defined as CHARACTER SET utf8mb4
– Praveen Yadav
Dec 3 '17 at 17:52
bytes in the csv file is UTF-8,columns defined as CHARACTER SET utf8mb4,table defined as CHARACTER SET utf8mb4
– Praveen Yadav
Dec 3 '17 at 17:52
And the settings for phpmyadmin?
– Rick James
Dec 3 '17 at 20:02
And the settings for phpmyadmin?
– Rick James
Dec 3 '17 at 20:02
And the
<meta ... in the html?– Rick James
Dec 3 '17 at 20:03
And the
<meta ... in the html?– Rick James
Dec 3 '17 at 20:03
And the hex of the data in the table?
– Rick James
Dec 3 '17 at 20:03
And the hex of the data in the table?
– Rick James
Dec 3 '17 at 20:03
yes i have a meta tag,
<meta charset="UTF-8"> in my html,– Praveen Yadav
Dec 3 '17 at 20:09
yes i have a meta tag,
<meta charset="UTF-8"> in my html,– Praveen Yadav
Dec 3 '17 at 20:09
|
show 10 more comments
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f192274%2futf-8-showing-correct-in-database-but-not-in-webpage%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
