trouble with some utf-8 characters

  • I’m working on bringing my blog over to WordPress and things are going pretty well except I’m having some problems with some characters when I write czech words. For instance, when I write Tě?ím some of the wacky characters are saved correctly but not others. If I edit the post and type the bad letters again they show up on my screen until I save the update, then revert back to ?’s

    This is a brand-new install of WordPress 2.7.1 so I assume it should be good with utf-8, and I’ve made sure the files I import are utf-8 as well (though even typing directly doesn’t work). I’ve tried different browsers on different platforms with the same results.

    Any ideas? Getting those characters right is pretty important.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter vikingjs

    (@vikingjs)

    Should I be asking over in the advanced area?

    I should mention I suppose the rest of my setup, I suppose:

    Apache version 2.2.10 (Unix)
    PHP version 5.2.6
    MySQL version 5.0.67-community-log
    MySQL charset: UTF-8 Unicode (utf8)
    MySQL connection collation: utf8_unicode_ci
    character set results utf8

    *sigh* I thought the whole point of unicode was to eliminate hassles like this, but there seems to still be a lot of stuff in formatting.php to deal with character entities.

    Thread Starter vikingjs

    (@vikingjs)

    Now, looking more at phpMyAdmin, I see that the default collation for the database is utf8_unicode_ci, however the database instance created when I ran the automatic WordPress creator has a collation of latin1_general_ci, and fields like post_content also have a latin collation. Is this important? It seems like this shouldn’t really be a collation issue.

    When I use the phpMyAdmin to browse the database contents, the characters appear to already be altered in the tables, if that matters. (At least, they’re altered by the time they reach my screen.)

    kmessinger

    (@kmessinger)

    Try ampersand#283; for ě ampersand#353; for š from https://www.fileformat.info/info/unicode/block/latin_extended_a/utf8test.htm

    í is ampersand#237; from https://www.fileformat.info/info/unicode/block/latin_supplement/utf8test.htm

    It would be a pain to have to put these in everytime but maybe the links will help. Looks like you need latin extended and latin supplement.

    Thread Starter vikingjs

    (@vikingjs)

    All right! I fixed it! Hopefully this will help if someone else has a similar problem. A question remains in my mind how the database was created incorrectly in the first place, since I just let the automated systems handle it.

    Here’s the deal: although mySQL was set to use utf-8 by default, and despite the fact that this was a brand-new install with wp-config clearly set to utf8, the database was in latin1. I haven’t the slightest idea why, but I installed through fandango, so maybe something was out of date with that.

    Anyway, since I didn’t have any real data to worry about yet, I was able to follow these instructions to get the most important fields changed. Things were looking a lot better, but there were still quite a few fields using latin1. Rather than fiddle with them individually I fired up utf-8 database converter by g30rg3x, ignored all the dire warnings, and wound up with an all-utf8 database just waiting to be populated with all those wacky Eastern European characters.

    kmessinger

    (@kmessinger)

    those wacky Eastern European characters

    Yes, I knew one of those guys . . .

    Glad you got it working.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘trouble with some utf-8 characters’ is closed to new replies.