WordPress.org

Ready to get started?Download WordPress

Forums

Really Simple Events
[resolved] Handling international characters (16 posts)

  1. muranyia
    Member
    Posted 1 year ago #

    International (UTF-8) characters get messed up when saving an event.

    http://wordpress.org/extend/plugins/really-simple-events/

  2. huntlyc
    Member
    Plugin Author

    Posted 1 year ago #

    Hi Muranyia,

    Thanks for taking the time to post, what exactly are you trying to enter and into which field? If you let me know I can test this out.

    There have been issues with this before, but they had been resolved...

    Cheers,

    Huntly

  3. muranyia
    Member
    Posted 1 year ago #

    Hello Huntly,

    thanks for the reply. I'm adding a new event and inserting a title with accented characters. Right after pressing "Update Event" the title gets messed up. The content of "Extra Event Info" stays intact.
    It seems that every time I update the event the title gets messed up further.

  4. huntlyc
    Member
    Plugin Author

    Posted 1 year ago #

    OK, thanks for the extra info, I'll look into this.

  5. huntlyc
    Member
    Plugin Author

    Posted 1 year ago #

    Hi muranyia,

    I've tried to recreate this issue and have been unable to do so...

    My working theory is that the database character encoding hasn't been set correctly and is set as latin1 rather than utf-8. There's a pretty straight forward way to check/fix this.

    If any of this makes you uncomfortable or you're not sure, then PLEASE EMAIL ME before you accidentally take out your whole WordPress install! (huntly.cameron@gmail.com)

    You can check to see what the table is using pretty easily:
    * Install the 'Adminer' Plugin
    * Go to the "settings" menu on the wordpress admin and select adminer
    * Open in a new tab
    * Find this table in the right-hand column "wp_reallysimpleevents"
    * it *should* say beside it in one of the columns 'utf8_general_ci'

    If it doesn't say 'uft8' then you're going to have to manually change it, but you can do this with adminer. NOTE!!!! I can't accept any responsibility for any data loss that you might have!!! In saying that, I've done this before and didn't have any problems...

    Click "sql command" and execute the following:

    ALTER TABLE wp_reallysimpleevents CONVERT TO CHARACTER SET utf8;

    That should fix it, if it doesn't then there is one last command you can try:

    alter table wp_reallysimpleevents change title title VARBINARY(255);
    alter table wp_reallysimpleevents change title title VARCHAR(255) character set utf8;
  6. muranyia
    Member
    Posted 1 year ago #

    Howdy Huntly,

    it's alrite, i'm pretty familiar with SQL.
    I've checked and the table and both textual fields are utf8_general_ci.
    I have also created an event by SQL, and I think I have found some clue: with perfectly good data in the table, Event Title is displayed scrambled in Edit Event (and only there). So the characters must get messed up when displayed not when saved.

  7. huntlyc
    Member
    Plugin Author

    Posted 1 year ago #

    Thanks for the quick feedback muranyia, I can only apologize for the lateness of mine, it's been a busy old week!!!

    Am I right in assuming that the title only screws up in the edit event page? So when you create an entry with SQL it shows up fine in the front end and also in the view events admin page?

    Cheers,
    Huntly

  8. muranyia
    Member
    Posted 1 year ago #

    Yes, exactly. Of course, when I save the messed up title, it's saved as it is, messed up.

  9. huntlyc
    Member
    Plugin Author

    Posted 1 year ago #

    Hi muranyia, I've just published an update to the plugin that should hopefully fix this for you... Because I was unable to recreate this issue, could you let me know if the update works for you?

    Thanks for your patience!!!

  10. muranyia
    Member
    Posted 1 year ago #

    Nope :(
    (plus I got an error "Could not create event! HELP!!" when I tried to change the name of an event and save it, but I cannot reproduce this one)
    FYI, this is WP version 3.5.1–hu_HU

  11. huntlyc
    Member
    Plugin Author

    Posted 1 year ago #

    Hahaha, and so the saga continues... :)

    What exactly is the text you're putting in? I only ask because I've managed to get away with all sorts of weird and wonderful characters I never even knew existed! However, I'll go download that version of wordpress and see what happens.

    Cheers,

  12. huntlyc
    Member
    Plugin Author

    Posted 1 year ago #

    Ok, so I've installed that version of WordPress and have managed to add an event with some example Hungarian text. I was then able edit the title and all seems to be working fine.

    I've uploaded some screen shots to make sure we're both on the same page.
    Initial:
    https://www.dropbox.com/s/6h0buglayx27dcf/eventsgrap.png
    Edit and update:
    https://www.dropbox.com/s/ca1nieqkxv4m8sm/eventsgrab2.png

  13. muranyia
    Member
    Posted 1 year ago #

  14. huntlyc
    Member
    Plugin Author

    Posted 1 year ago #

    Ah, ok, I've just published another update, hopefully you should see it soon. Here's hoping that this fixes it...

  15. muranyia
    Member
    Posted 1 year ago #

    Lo and behold: yep!
    It' so fixed.
    Thanks a lot Huntly!

  16. huntlyc
    Member
    Plugin Author

    Posted 1 year ago #

    Good stuff! Glad we got to the bottom of that. Thanks for all your help!

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags