This is a brief tutorial on how to update your AWSOM News Announcement database table to display any language type you’d like. It’s actually pretty straight forward. It’s best if you do not have any news posts saved since changing the language type might make them display incorrectly.

First thing you need to do is go to your web server and go to your MySQL administration tool. Typically this is a program called PhpMyAdmin (which I’ll be using to demonstrate–but any program will work as long as you can access the same areas I’ll be showing).

Start by selecting your WordPress database. This is the database you input into the wp-config.php file when you originally set up WordPress. You can select from your current databases by using the drop down menu on the left side:

Once you’ve selected the correct database you need to go to the AWSOM News Announcement table that’s in the database. It is named awsomnews but has a header prefix that’s typically wp_, but could be a custom one that you added to the wp-config.php file. click it’s name in the list under your database name on the left and it should open a new page in the main area showing details of that table.

Notice that there is a column called “collation” and it lists “latin1_swedish_ci”–this is the default language type that MySQL uses unless specifically told to use a different language type (MySQL is originally a swedish product). This language type does not display Asian or other non-English lettering based languages well (and honestly has issues with regular English also). What we need to do is change this to the correct language for you.

You can do one of 2 things at this point. You can mark the checkbox next to “newstext” and click the bottom pencil icon or more simply click the pencil icon in the same row. This will open up the individual field for editing.

Now, the difficult part. In the collation drop down select the language type you’d like. Yes, there are a very large number of them and it’s not always easy to know which one to use. For regular English “utf8-bin” is good. You’ll need to look this up for your own language since I have no idea what’s good for any other specific language. Once you know which one you want make sure it’s selected in the drop down box. Then click the “save” button.

That’s basically it. Go and try it out.