MySQL Forums
Forum List  »  MySQL for Excel

Is there any solution by which mySQL can import subscript and superscript as it is from excel?
Posted by: Faisal Nadeem
Date: April 01, 2019 04:23AM

We have a lot of chemistry, Physics and Math MCQs in an excel file with lot of formulas and equations. When we tried to import these MCQs into mySQL based database all subscripts and supercripts used in formulas lost and taken as normal character e.g, H2SO4, CO2, CH3 etc and makes our formulas and elements name nonsense. Is there any solution by which mySQL can import subscript and superscript as it is from excel? Or Is there any solution so we can force excel to consider subscript and superscript as inserted symbols because mySQL can pick symbols as it is?
Rightnow we are replacing sub and super scripts with same type of symbols manually so that it can be remain the same after importing into the mysql for our web application.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.