UTF8mb4 characters are showing strange content in word document [closed]
I have to store IPA(International Phonetic Alphabets) characters in to MySQL(charset- utf8mb4) from HTML and when a user clicks download button the content in MySQL table have to be saved in to a word document.
My problem is when I am downloading to word document. The IPA characters are shown as strange characters.
I have changed the Connection object charsets to utf8mb4 and its working well with HTML, PHP and MySQL communication.
$db38 = mysqli_connect($host, $user, $pass, $dbnm );
mysqli_set_charset($db38,"utf8mb4");
Further info I got to know that each IPA character has a decimal value and have to represent as #&value; but these are dynamic inputs from user
and the characters are storing correct in DB.I was able to show the result set from DB on to a HTML page as well.
Expected results
MySQL Word
-------- --------
hɑʊs hɑʊs
dɔr dɔr
Actual result
MySQL Word
-------- --------
hɑʊs hÉ‘ÊŠs
dɔr dÉ”r
php mysqli ms-word
asked Jan 18 at 18:55
N PN P
11
closed as off-topic by Dharman, Cindy Meister, deceze♦ Jan 18 at 19:33
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself. Questions without a clear problem statement are not useful to other readers. See: How to create a Minimal, Complete, and Verifiable example." – Dharman, Cindy Meister, deceze
If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
I have to store IPA(International Phonetic Alphabets) characters in to MySQL(charset- utf8mb4) from HTML and when a user clicks download button the content in MySQL table have to be saved in to a word document.
My problem is when I am downloading to word document. The IPA characters are shown as strange characters.
I have changed the Connection object charsets to utf8mb4 and its working well with HTML, PHP and MySQL communication.
$db38 = mysqli_connect($host, $user, $pass, $dbnm );
mysqli_set_charset($db38,"utf8mb4");
Further info I got to know that each IPA character has a decimal value and have to represent as #&value; but these are dynamic inputs from user
and the characters are storing correct in DB.I was able to show the result set from DB on to a HTML page as well.
Expected results
MySQL Word
-------- --------
hɑʊs hɑʊs
dɔr dɔr
Actual result
MySQL Word
-------- --------
hɑʊs hÉ‘ÊŠs
dɔr dÉ”r
php mysqli ms-word
asked Jan 18 at 18:55
N PN P
11
closed as off-topic by Dharman, Cindy Meister, deceze♦ Jan 18 at 19:33
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself. Questions without a clear problem statement are not useful to other readers. See: How to create a Minimal, Complete, and Verifiable example." – Dharman, Cindy Meister, deceze
If this question can be reworded to fit the rules in the help center, please edit the question.
what results return , mysqli_set_charset($db38,"utf8");
– Dito Khelaia
Jan 18 at 19:09
How do you generate that Word document…?
– deceze♦
Jan 18 at 19:33
add a comment |
I have to store IPA(International Phonetic Alphabets) characters in to MySQL(charset- utf8mb4) from HTML and when a user clicks download button the content in MySQL table have to be saved in to a word document.
My problem is when I am downloading to word document. The IPA characters are shown as strange characters.
I have changed the Connection object charsets to utf8mb4 and its working well with HTML, PHP and MySQL communication.
$db38 = mysqli_connect($host, $user, $pass, $dbnm );
mysqli_set_charset($db38,"utf8mb4");
Further info I got to know that each IPA character has a decimal value and have to represent as #&value; but these are dynamic inputs from user
and the characters are storing correct in DB.I was able to show the result set from DB on to a HTML page as well.
Expected results
MySQL Word
-------- --------
hɑʊs hɑʊs
dɔr dɔr
Actual result
MySQL Word
-------- --------
hɑʊs hÉ‘ÊŠs
dɔr dÉ”r
php mysqli ms-word
asked Jan 18 at 18:55
N PN P
11
I have to store IPA(International Phonetic Alphabets) characters in to MySQL(charset- utf8mb4) from HTML and when a user clicks download button the content in MySQL table have to be saved in to a word document.
My problem is when I am downloading to word document. The IPA characters are shown as strange characters.
I have changed the Connection object charsets to utf8mb4 and its working well with HTML, PHP and MySQL communication.
$db38 = mysqli_connect($host, $user, $pass, $dbnm );
mysqli_set_charset($db38,"utf8mb4");
Further info I got to know that each IPA character has a decimal value and have to represent as #&value; but these are dynamic inputs from user
and the characters are storing correct in DB.I was able to show the result set from DB on to a HTML page as well.
Expected results
MySQL Word
-------- --------
hɑʊs hɑʊs
dɔr dɔr
Actual result
MySQL Word
-------- --------
hɑʊs hÉ‘ÊŠs
dɔr dÉ”r
php mysqli ms-word
php mysqli ms-word
asked Jan 18 at 18:55
N PN P
11
asked Jan 18 at 18:55
N PN P
11
edited Jan 18 at 19:08
N P
asked Jan 18 at 18:55
N PN P
11
asked Jan 18 at 18:55
N PN P
11
asked Jan 18 at 18:55
N PN P
11
11
closed as off-topic by Dharman, Cindy Meister, deceze♦ Jan 18 at 19:33
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself. Questions without a clear problem statement are not useful to other readers. See: How to create a Minimal, Complete, and Verifiable example." – Dharman, Cindy Meister, deceze
If this question can be reworded to fit the rules in the help center, please edit the question.
closed as off-topic by Dharman, Cindy Meister, deceze♦ Jan 18 at 19:33
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself. Questions without a clear problem statement are not useful to other readers. See: How to create a Minimal, Complete, and Verifiable example." – Dharman, Cindy Meister, deceze
If this question can be reworded to fit the rules in the help center, please edit the question.
what results return , mysqli_set_charset($db38,"utf8");
– Dito Khelaia
Jan 18 at 19:09
How do you generate that Word document…?
– deceze♦
Jan 18 at 19:33
add a comment |
what results return , mysqli_set_charset($db38,"utf8");
– Dito Khelaia
Jan 18 at 19:09
How do you generate that Word document…?
– deceze♦
Jan 18 at 19:33
what results return , mysqli_set_charset($db38,"utf8");
– Dito Khelaia
Jan 18 at 19:09
what results return , mysqli_set_charset($db38,"utf8");
– Dito Khelaia
Jan 18 at 19:09
How do you generate that Word document…?
– deceze♦
Jan 18 at 19:33
How do you generate that Word document…?
– deceze♦
Jan 18 at 19:33
add a comment |
0
active
oldest
votes
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
what results return , mysqli_set_charset($db38,"utf8");
– Dito Khelaia
Jan 18 at 19:09
How do you generate that Word document…?
– deceze♦
Jan 18 at 19:33