Storing Both English and Spanish information in the same table
Have a customer site that runs in both English and Spanish (one language at a time of course) and I thought I had everything planned out, right up until I added the Spanish information into the products table. Once entered all the special Spanish characters became 'hieroglyphics' for lack of a better term.
For example: MARRÓN/NEGRO added to the table has become MARRÃâN/NEGRO
The db is collated latin1_general_ci is there another collation I should be using that would work for both languages?
Sorry if this is an elemental problem, first time I have ever used a foreign language in a database.