By mgharris on
Ok, after a massive failure of one of my servers which I could not diagnose I took the extreemly drastic step of reinstalling drupal from the very beginning. Thankfully, everything I needed was backed up and ready to go so this was a very easy task.
I do remember seeing an article on this issue pop up on the Drupal site some time ago which i've not been able, but after re-importing the database I have had various symbols such as ���?� and ���? have appeared in my node entries.
Has anyone got a quick solution to fix up this issue short of having to re-edit all my articles? All & any help appreciated.
thewinchester
Comments
Thanks for the detailed information
Well, the Drupal developers are all omniscient and clairvoyant so we could easily discover what's going on with an anonymous computer thousands of miles away. But using our superhuman powers is -- alas -- very tiring so we prefer to read detailed reports. OS information, Apache, MySQL, PHP versions may be relevant when dealing with a server issue.
In this case my guess would be MySQL 4.1 and collate problems. Search/google for more information.
--
Read my developer blog on Drupal4hu.
--
Drupal development: making the world better, one patch at a time. | A bedroom without a teddy is like a face without a smile.
My brain was turned off
Yes, chx - that information would have been useful now wouldn't it.
It's Windows Server 2003, IIS6, PHP5.0.4.4, and MySQL 4.1.12a-nt. Site was restored from a database backup.
and that backup was made
and that backup was made under MySQL 4.0 or less, right?
--
Read my developer blog on Drupal4hu.
--
Drupal development: making the world better, one patch at a time. | A bedroom without a teddy is like a face without a smile.
Database creation?
I'm trying to recall the details, but I remember someone else discussing the same issue a few weeks ago in a similar situation. When a MySQL database is created, one can select the encoding type for text fields. IE, 'UTF8' or what not. If you backup a DB in one format and import it into a DB created in another, you'll get all sorts of crazy goofiness when extended characters are used.
Something to check, at least?
--
Eaton — Partner at Autogram
What format?
What format are Drupal Databases in then?
I ran into this many times when I used a DUMP from cocco MySQL which defaulted to UTF8 encoding.
When restoring the database... I ran into all sorts of strange characters.
Should we be selecting US ASCII or ISO Latin?
Thanks
David McIntosh
neofactor.com