Mysql and special chars on keys

Question

In mysql with "latin1_swedish_ci" collation these records:

   INSERT INTO test VALUES ('è');
   INSERT INTO test VALUES ('e');

are the same... If this varchar colum is a primary index and I try to inser these values I get a duplicate primary key error. Is it possibile to change this behaviour?

thanks

score 0 · Answer 1 · edited May 23 '17 at 11:56

0

Which version of MySQL are you using? It could be a unicode problem

MySQL VARCHAR Lengths and UTF-8

edited May 23 '17 at 11:56

Community

1
1

answered Jun 25 '13 at 10:41

KeepCalmAndCarryOn

8,511
2
29
45

on the other hand it might be your character_set_client http://stackoverflow.com/questions/12260386/change-variable-in-mysql – KeepCalmAndCarryOn Jun 25 '13 at 10:50

score 0 · Answer 2 · answered Jun 25 '13 at 11:22

0

you can insert ascii code to db as the following

INSERT INTO test VALUES ('232');
INSERT INTO test VALUES ('101');

Then you can read them and in php use chr function to get character.

answered Jun 25 '13 at 11:22

Ayman Hussein

3,783
4
25
48

Mysql and special chars on keys

2 Answers2