CODEWITHSUNDEEP
mysqldatabaseencodingcharacter-encoding
Philip Kirkbride
Philip Kirkbride

Reputation: 22879

Importing to mySQL causes blank space to convert to 'Â'

When I import a table of descriptions any extra spaces beyond the first convert into  symbols in the database. How can I prevent this?

Upvotes: 2

Views: 1065

Answers (1)

Philip Kirkbride
Philip Kirkbride

Reputation: 22879

Running the following MySQL query fixed the problem.

ALTER DATABASE YourDatabase CHARACTER SET utf8;

Upvotes: 2

Related Questions