I'm attempting to do the following in MySQL (via PHP):
INSERT INTO letters (letter) VALUES ('e')
INSERT INTO letters (letter) VALUES ('é')
...but keep getting the following message:
#1062 - Duplicate entry 'é' for key 'letter'
The "letter" field is the primary field, making me think that perhaps MySQL is thinking that the 'é' character is the same as the 'e' charter for some reason.
The value 'é' itself comes from (and tries to write to) a MyISAM table with a
latin1_swedish_ci character set ( - the default settings when I create a new table)
Can anyone advise me how to get around this or why its happening?