Home » Web Design and Development » Database » How to store Marathi, Kannada ( Indian languages ) in MySQL database ?

How to store Marathi, Kannada ( Indian languages ) in MySQL database ?

One of our website which we had started is developed using PHP and uses MySQL as database. This software we had purchased from another company, so when we installed started using, whenever our users updated their information in Indian languages like Marathi, the database was saving this information as only question marks like “?????”

Problem :

This was happening because, when we checked our database configuration using phpmyadmin. The collation was set to “utf32_spanish_ci”

Solution :

We changed the database collation from “utf32_spanish_ci” to “utf8_general_ci” using phpmyadmin. You can follow our another post “How to change database collation using phpmyadmin ?” for changing the collation.

Leave a Comment