InMotion Hosting Support Center

Vietnamese in Posts

Category: Wordpress

2013-06-25 12:45 am EST

Hits: 1,085
I'm running WP 3.5.2 and would like to be able to show Vietnamese language in some titles and in some content of posts. Don't want to change the language of the site (like the admin or menus) - just want to be able to show the occasional Vietnamese word with tone marks and so forth. Currently when I put Vietnamese in it will swap out characters for ??? or symbols on save.

I've done some looking but am not finding recent articles related to this. Based on some things I have read, I went to the cPanel and to phpMyAdmin and saw that the general setting for Server Connection Collation is utf8_general_ci. I tried to change that to utf8_unicode_ci but this did not seem to make any difference.

Appreciate any assistance from those with more knowledge / experience.

You must login before you can ask a follow up question.

You must login before you can submit an answer.

Best answer chosen by User


43,761 Points
2013-06-25 9:52 am EST
Hello aj_partner,

I am unable to locate your account with the information provided, so I am only able to answer generally.

The charset for utf8 will support the same languages, no matter whether using general_ci or unicode_ci. The differences in those two formats is located in the sorting algorithms, which will not affect what is able to be displayed. You will want to check and ensure that your individual tables are not set to Latin-1, and also check your wp-config.php file to ensure the DB_CHARSET is utf8, which it should be, by default.

Below is an article on how to convert your database to utf:
How to convert a database to UTF-8

Best Regards,
Scott M

You must login before you can post a comment about this answer.

Thanks Scott for your help. I'm not that technical so I took a little bit to understand and work through this but I do have it working now. I checked my wp-config.php file and it was set already to utf8. I experimented with changing it to utf8_general_ci which allowed the VN to show up correctly but screwed up some other symbols. So I reversed that edit and went with the running the script as outlined in the article you linked here. I simply put the charset to utf8 and ran the script and now the VN shows up correctly. Thanks for the help.
8 Points
2013-06-26 12:14 pm EST
Like this Question?

Need more Help?


Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail:
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!