UTF8mb4 characters are showing strange content in word document [closed]












-1















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







share|improve this 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
















-1















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







share|improve this 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














-1












-1








-1








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







share|improve this question
















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






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Jan 18 at 19:08







N P

















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



















  • 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












0






active

oldest

votes

















0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes

-

Popular posts from this blog

Homophylophilia

Image
Haec pagina ad tempus protecta est ob maleficia perpetua. Quaesemus, emendationes suggere in pagina disputationis vel magistratum ad hanc deprotegendam pete. Homophylophilia Hyacinthus complexus ab amante suo Apolline, in pictura Mors Hyacinthi quam Jean Broc pinxit. Homophylophilia est sui sexus vel generis amor vel mores romantici vel sexuales, res venerea masculina in masculos, aut mulier in mulieres appetentes. Hoc ingenium sexuale est "exemplar permanens vel inclinatio ad experiendam sexualem, adfectionalem, vel romanticam vim attrahendi," praecipue vel solum ex hominibus eiusdem sexús; notio "etiam ad hominis iudicium identitatis privatae socialisque in illis attractionibus conditum refert, in moribus quoque qui illos exprimant, et in societate communitatis aliorum qui illos communicent." [1] [2] Per aevos alii aliter rem definiverunt, sed Occidentali nostrae aetatis cultu civili non tantum ad ipsa acta erotica spectat, sed etiam igitur
Read more

Updating UILabel text programmatically using a function

Image
0 so I am trying to update the UIlabel text using a func. I have seen few other questions like mine and I tried their method but it doesn't work. fun returns no value when used in the UIlabel. I have shown my code below.It has to be noted that when I use the function in viewdidload I can retrieve the data. lazy var name: UILabel = { let lb = UILabel() lb.text? = getthename() lb.lineBreakMode = NSLineBreakMode.byWordWrapping lb.textColor = .mainGreen lb.textAlignment = .left lb.font = UIFont.boldSystemFont(ofSize:12.0) return lb }() func getthename() -> String { var wins : String = "" let ud = (Auth.auth().currentUser?.uid) self.ref = Database.database().reference() self.ref.child("Users").child(ud!).observeSingleEvent(of: .value, with: {(snapshot) in
Read more

Cloud Functions - OpenCV Videocapture Read method fails for larger files from cloud storage

Image
0 I created a cloud function to read a video file from cloud storage and read frames and create an image for each frame. This function works for small files which is 1-2 MB, However, this method fails while reading larger file 130 MB. import cv2 from google.cloud import storage vidcap = cv2.VideoCapture("https://storage.googleapis.com/[bucker_name]/[filename.mp4]") if vidcap.isOpened(): vidcap.open("https://storage.googleapis.com/[bucker_name]/[filename.mp4]") success,image = vidcap.read() print(success) Expected the print will return true and an image will hold an image of a first frame. python-3.x function opencv cloud share | improve this question
Read more