Saturday, November 23, 2013

Webmin change default charset (encoding) for MYSQL database UTF-8

When you see special characters in mysql, like (Æ Ç È É Ê Ë Ì Í Î Ï Ð Ñ Ò Ó Ô Õ Ö × Ø) it means you need to set default charset for mysql database records. I've been figuring it out for couple weeks, to find where is the place in webmin to change default charset and encoding for mysql database recods.

Follow thees steps to change it:

Go to Servers >
Go to MySQL Database Server >
The select on the top of the page Module Config >
From drop down menu next to Configuration category select System configuration >
Go to second page and change the Character set for MySQL.

Hope that will help someone.