ulenie Posted November 21, 2006 Share Posted November 21, 2006 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? Quote Link to comment Share on other sites More sharing options...
the_oliver Posted November 21, 2006 Share Posted November 21, 2006 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 Link to comment Share on other sites More sharing options...
ulenie Posted November 22, 2006 Author Share Posted November 22, 2006 [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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.