I'm trying... really, but I'm SO confused about character encoding and MySQL collation. The more I read about it, the more confused I get. So let me ask 2 SIMPLE questions.
For a US based website that deals only with the English language, is:
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
the correct encoding?
2nd, in MySQL, all my collation has defaulted to latin1_swedish_ci. Is this NOT correct for a US/English based website? I tried changing fields over to utf8_general_ci and it returned this error: "Column 'description' cannot be part of FULLTEXT index".
Ok, let me get greedy and throw in a 3rd question. If I have a webpage that has the WRONG charset, and data is retrieved via a form and put into MySQL with the RIGHT charset. What are the consequences if the two charsets aren't set right?