How to solve malayalam or any other font display error in wordpress

If your wordpress site don't show malayalam or any other fonts then no need to worry. It is a simple problem in your database.

Problem

Post title and post content accepts malayalam font and when you publish the post then it displays only ???????? characters.

Before publishing : After pasting malayalam texts in title and content page, It looks like below

malayalam font display error in wordpress 1

After publishing : Title and content page looks like below

malayalam font display error in wordpress 2


Solution

The problem is that your database encoding format don't support malayalam character encoding. So we should change database encoding into any other encoding form that support malayalam fonts. To correct this problem do the following operations

Goto your cpanel –> click PHPMyAdmin –> select your database –> select posts table –> select structure. Then the table looks like below

malayalam font display error in wordpress 3

Change your column collation from latin_swedish_ci (or any other format) to utf8_general_ci

malayalam font display error in wordpress 4

Now you can add malayalam fonts in your post.


 

You can leave a response, or trackback from your own site.

2 Responses to “How to solve malayalam or any other font display error in wordpress”

  1. Britta says:

    Hello,

     

    This plugin does not work properly for me. It doesnt work for post title also for the editor it justt shows squares instead of malayalam fonts. But when listed in front-end it appears perfect..Can you please help..?I am using the latest wordpress 3.51

    • Jijo K Jose says:

      This is not about your plugin or even wordpress version. The problem occurs due to the character encoding format so please change your database character encoding format so that it will accept any language. This problem mainly occurs when you are installing wordpress using any web service ( like Fantastico in Cpanel ). So i recommand that you should install wordpress using the zip file from the worpress.org website.

Leave a Reply