Posts get crop at "’" apostrophe? UTF8 problem?

  • Resolved Nicolas

    (@monstermodification)


    13 years ago

    Please help!

    Yesterday I noticed that a lots of my posts are cropped as soon as there is an apostrophe “’” in them. I think it is always happening with other special characters.

    I restored a backup of my database and it is still doing it. I’m lost! I know these articles were working recently..

    If I edit my database in text editor I can see my post are there and complete.

    I tried a plugin to convert my database to UTF8 .. it didn’t help.
    My database is already UTF8..

    I installed a fresh copy of wordpress and uploaded different database backup.. but my posts are still getting truncated as soon as there is “’” character.

    Is there a way to easily extract my posts from the database? I’ll just recreate a new database and.. copy everything back to a new installation.

    Thanks a alot

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter Nicolas

    (@monstermodification)

    13 years ago

    If you’re more visual take a look at my screenshot please.

    You will understand what I mean

    [IMG]http://i43.tinypic.com/ayne4l.png[/IMG]

    essaysnark

    (@essaysnark)

    13 years ago

    I’m suspecting a badly-coded plugin or theme. Did you try disabling all of them and loading the TwentyEleven theme?

    Thread Starter Nicolas

    (@monstermodification)

    13 years ago

    it’s okay I fixed it.. but I’ll still do a complete re installation and this time instead of copy/pasting my posts.. I will type them manually to ensure this is not going to happens again

    I edited my SQL dump database, I had to do a search/replace for these characters:

    [ Moderator note: fixed with the code button. ]

    "’"
" "
"–"
"“"
"”"
"—"

    not sure what happened because it was working fine.. then suddenly all my post that contained these kind of special characters were cropped after these characters.

    Thread Starter Nicolas

    (@monstermodification)

    13 years ago

    So basically I looked every post at where they were truncated, and did a search in my DB.. and right after the place where it stop. I could see these special characters.. so I replaced them with a valid character

    for example i replaced all the “—” by “-“

    and removed all these strange invisible characters ” ” for ” ” (a white space)

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Posts get crop at "’" apostrophe? UTF8 problem?’ is closed to new replies.

Tags