Sub_Seven - 12:06 am on Mar 3, 2011 (gmt 0)
Could someone <<please>> tell me what is the best way to insert spanish characters like áéíóúñ and such into MySQL?
I just do not understand this, I have a DB at work where I have done it before and now I am working in this new project and things just don't work, I have tried several different types of collations and they seem to be indifferent to the problem, I have tried both htmlentities and htmlspecialchars and the result is just the same, I get things like this inserted when I do tests: Ã¡fffÃ©
This is part of my code right now
$sql="INSERT INTO cp_category (cp_cat_line, cp_cat_name)
VALUES ('$line', '$name')";
I am in actual physical pain from the frustration, this can't be so difficult, any help as always will be extremely appreciated, thanks.