Page 1 of 1
Strange character appeared... maybe not cmsms related
Posted: Thu Mar 03, 2005 6:10 am
by jptechnical
I just moved a website to another server and domain and in moving the database I ended up with a really strange character on the front page. � if you can see it, it is a diamond with a question mark in it...
It doesnt show up in IE only in firefox but it was there in the wysiwyg editor for the content item.
Anyway... I havent seen or used this character before and wondered if anyone has ever had it pop up somewhere.
It is just too strange.
Re: Strange character appeared... maybe not cmsms related
Posted: Thu Mar 03, 2005 8:01 pm
by jptechnical
That is exactly what it was... I had the same issue when I tried to upload the sql dump.
The wampserver I have been trying out has been putting this latin1 collation thing on all the database tables and when I try to upload the dump including structure it always fails with this unknown sql query element.
Honestly, I know very little about the structure of databases... enough to fix things but not enough to claim any authority. My workaround was to install the CMSMS and the PHPBB and OSCommerce and then empty the tables and then dump the data only... no structure from the other database on the local test server and then merge it into the new database.
So, do you know why this latin1 attribute would be applied to the wampserver and not to ANY other test server I have tried. I will look to see if there is some language or encoding option I missed. Though it did it to ALL databases I made on the test server... so it isn't related to one of the scripts.
Thank you so much for replying... it is nice to know that those 2 issues were related.