Looked and looked but can't figure it out

[ulenie]

Ok, I have a csv parser file that parses the csv I put into a text box and stores it in a database.  I has been working nicely until yesterday, when I moved it from a sub-domain folder to the root folder.  I can't really see how that is causing the problem but what its doing is when ever it inputs a field from the csv that is called "Campaign" in to the database it keeps inputing this weird "Â" character in front of characters like "® ", "¢", "™" and other not every day characters.  So this is what it would do:  It stores "SunRocket® VoIP + Free Cordless Phones" instead of "SunRocket® VoIP + Free Cordless Phones".  I never touched the database structure, and this is how the campaign row is set up:    `name` varchar(255) NOT NULL default '',.  Does anyone know why its doing that?

[the_oliver]

Are this charictors being typed as plain text or using the html number equivelent?
If your just typing ® or anything slightly unusual like it thry using the html number equivelent. eg ® can be writen as [code]®[/code]

Let me know if that works.

[ulenie]

[quote author=the_oliver link=topic=115807.msg471645#msg471645 date=1164149856]
Are this charictors being typed as plain text or using the html number equivelent?
If your just typing ® or anything slightly unusual like it thry using the html number equivelent. eg ® can be writen as [code]®[/code]

Let me know if that works.
[/quote]

No, I actually download the csv from a site and its in plain text.  Anyways, i moved the file back to the sub-domian, like how it was and its working nicely.  I don't see how being a subdomain affects this but I guess I will keep it there, until I figure it out.