Announcement

Collapse
No announcement yet.

Foreign characters in posts/threads following db import

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Foreign characters in posts/threads following db import

    Hiya,
    Our host kindly switched us servers, by surprise, and made a balls up of the VB database. Thankfully I was able to make a clean backup from the old server and got back three days of lost data.

    However there are now foreign characters (Â) appearing throughout posts, usually occurring before the pound (£) symbol like so £.

    I've searched the forum and followed the guidance in this thread http://www.vbulletin.com/forum/showthread.php?t=259250. But that's made no difference.

    I've also reset the master language file via tools.php and I got so desperate I ran the following SQL queries on the database:

    Code:
    update thread set title = replace(title,'£','£');
    and
    Code:
    update post set pagetext = replace(pagetext,'£','£');
    But still the  appears.

    Does anyone have any suggestions to try?

    Thanks for any help or advice,

    Sy
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X