Convert Excel sheet having shivaji fonts to csv having google unicode utf-8 encoding

Question

I want to convert an Excel document that uses Shivaji fonts to a CSV file using Google's Unicode UTF-8 encoding.

I tried every approach, but I was unsuccessful because when I saved the file as a CSV, it displayed? I require the following symbols: à ¤Âà ¤•à ¤Ÿà ¤¾.

This file has to be imported into MySQL. Can someone please help me with this?

Answer 1

I take it that you mean "Shivaji font" to refer to Devanagari characters. I believe that you have been converted incorrectly twice.

I mimicked it by incorrectly converting to ààà—à%C2%8Dà2àà and then incorrectly converting that to â€" â€" 2, which closely resembles what you have. The file was twice transformed from utf8 to latin1 while it was moved around. Determine the specifics of the actions you made. At any point, if you can get a dump, do so. The hexadecimal Devanagari characters appear as E0A4yy, where yy is in the range of 80 to B1.