OK, I’ve been having some trouble getting unicode to display with WordPress, I tried upgrading, but nothing seemed to work. Finally I managed to get it working by editing wp-includes/wp-db.php and commenting out the lines setting the $collation_query to “SET NAMES utf8”. For some reason, this now seems to have things working and I can (at last) finish off my first real post on the blog (coming soon)!
Just for good measure, here’s a little unicode Hebrew: בראשית ברא אלהים את השמים ואת הארץ.
And here is a quick comment to determine whether Hebrew is working in the comments as well!
בר×שית ×‘×¨× ××œ×”×™× ×ת ×”×©×ž×™× ×•×ת ×”×רץ
With newer versions of WordPress the code here has changed and my “hack” to fix the problem is to comment out the two lines in the wp-db.php file in the __construct function which are:
if ( defined(‘DB_CHARSET’) )
$this->charset = DB_CHARSET;
Hello, Mr. Shields!
Thanks for the advice you left on my recent post lamenting my problems with getting wordpress to show Greek characters. Forgive my technical ignorance, but where do I find this wp-dp.php file? If I can just find it, I should have no problem implementing the edit you suggested, but I’m not seeing it.
Thanks again and a happy New Year,
Mitchell.
Nevermind. I worked it out. Thanks for the help!
Mitchell, no worries. I’ve just worked out another way to achieve the same end: edit the wp-config.php file and change the line:
define('DB_CHARSET', 'utf8');to:
define('DB_CHARSET', '');This has the same effect.
I note you’ve got a problem with non-breaking spaces now not displaying correctly. I don’t double-space text myself (not in line with most modern typesetting guidelines), but I’ll see if I can reproduce and fix the problem.
As to double-spacing, I realize I shouldn’t, but it was drilled into my head by an elderly but incredibly effective and strict typing teacher. It is only thanks to her that I can type effectively at all, rather than hunting and pecking. I’ve found a rather simple way to fix the non-breaking spaces (using find-replace in OpenOffice, one post at a time), so there’s no need to trouble yourself unless you find it interesting for its own sake. Again, thanks for the help.