solostream

Getting Hebrew to work on WordPress 2.2

| June 6, 2007 | 11 Comments

Update February 20, 2008:

The Hebrew no longer works on this blog, even with the trick I described below. Ido Fishman left a comment with a link to this section of the Codex that describes a gut-wrenching, hair-whitening way to get different languages to work on one WordPress blog. Since I don’t need Hebrew here, I’m going to pass on that and leave things as they are. In the meantime, if anyone finds a less stressful way to get multiple languages to work on a WordPress blog, please let me know.

The Hebrew version of this post is directly below the English, so scroll down my Hebrew-speaking friends…

????? ?????? ????? ???? ?????? ??????, ?? ???? ???? ???? ?????? ?????…

In an earlier post I described a problem I was having with Hebrew on WordPress 2.2. I found that every time I clicked on Save or Publish on a Hebrew post or Page, all of the Hebrew letters turned into question marks. After trying a million different ways to fix it, I gave up and downgraded the blogs that needed Hebrew to version 2.1.3, and then everything worked fine.

Well, I found the solution! Liew Cheon Fong at LiewCF has nonchalantly posted a simple solution that works, as if it’s not the most brilliant thing ever! (Ok, I exaggerate, but still…)

Here are his directions:

  1. Open and edit “wp-config.php”
  2. Find: define('DB_CHARSET', 'utf8');
  3. Remove “utf8?, so it becomes: define('DB_CHARSET', '');
  4. Save and upload “wp-config.php”
  5. Done. Your WordPress blog should display characters correctly.

Liew has saved me a lot of hair-pulling! Thanks Liew!

Now the Hebrew:

???? ????! ??? ??? ??? ?????? ????? ????? ?? ????? ???? ?????? ???, ????????? ?? “????” ?? ???? ?? ????, ?? ??????? ?????? ?????? ????. ???? ?????, ?? ?? ???? ???? ??? ???? ????? ?????? ???????? 2.2. ?? ??? ???? ????? ??????!

?? ??? ??? ?? ????? ???? ?????? ?? ????? ??? ????? ?? ?????, ???? ???????:

  1. ???? ?? ????? wp-config.php.
  2. ???? ?? ????? ??? ????: define('DB_CHARSET', 'utf8') – ?? ???? ????? 8.
  3. ???? ?? ?????? “utf-8″ ??? ??? ???? define('DB_CHARSET', '');
  4. ????? ????? ??? ???? ??? ??? FTP.
  5. ???!

Tags: , ,

Category: Tips

Elegant WP Themes

Comments (11)

Trackback URL | Comments RSS Feed

  1. Rona says:

    yey, it works!
    thanx =)

  2. Miriam says:

    Glad I could help!

  3. Meir Pinto says:

    I’m not translate template yet but it’s a good thing to know.

    BTW,
    What plugin did you use fir the tags & the tag CLOUD in your blog?
    Let me know if you can because i have tryed to put the tag cloud in my blog & it didn’t worked.
    Thank You,
    Pinto.
    http://www.pintophotography.com/wp/

  4. Miriam says:

    Meir – I used Jerome’s Simple Tagging and I wrote a whole tutorial about how to get it to work, which you can see here. If you follow the instructions, it should work for you too.

  5. [...] order to post in Hebrew, one must make a minor change to the wp-config.php file. Here’s an excellent post on the subject. Well, anything involving changing a config file is not minor. So I make the recommended change, [...]

  6. Ido Fishman says:

    Maybe it’s just me, but I still see ??? instead of hebrew on this post.

  7. Miriam Schwab says:

    Ido – how ironic! The reason is that I recently had to reinstall this blog, and I actually forgot to implement this little trick here. I’m going to do it now, so hopefully by the time you see this comment, the ??? will be gone.

  8. Miriam Schwab says:

    Ido – this trick isn’t working anymore! Now I don’t know what to do!

  9. Ido Fishman says:

    Although my new blog is completely in Hebrew and I’ve never tried to mix between English & Hebrew in my posts, except certain words or names, I think that you should follow this – http://codex.wordpress.org/Converting_Database_Character_Sets

    Don’t forget the backup part – very important.

  10. Miriam Schwab says:

    Ido – that is one scary way to  get Hebrew to work on WordPress. I think a person needs to back up and pray like crazy before doing such a thing.

    I think I’m going to live with the question marks for now since I just don’t have the stomach for that.

  11. [...] everything I had done during the database transfer. And, I remembered a very tiny detail.  The  UTF-8 tag in the wp-config.php [...]

Leave a Reply




If you want a picture to show with your comment, go get a Gravatar.