Results 1 to 10 of 10
Nov 9, 2009, 10:00 #1
- Join Date
- Nov 2004
- Right behind you, watching, always watching.
- 0 Post(s)
- 0 Thread(s)
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.