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.