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.

Command line execution

Terminalbash
sed 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.

Implementation details

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

Gotchas and common issues

  • Permission checks - verify user access rights and sudo privileges before executing system-level operations.

  • Environment configuration - double-check path variables and dependency versions to prevent runtime failures.

  • Backup safeguards - maintain configuration backups before applying system or database modifications.

Following these steps ensures clean configuration and reliable execution for store marathi, kannada ( indian languages ) in mysql database.