MYSQL BUG: Duplicate entry on Primary/Unique. If I insert word / word ,word / word

Wednesday, November 4, 2015

Hi,
I try to INSERT in my database 2 different words with PHP.



word / word <= *is the first*

word / word <= *is the secound with spaces tabs after slash*


Create Code:



CREATE TABLE `myWords_table` (
`myWords` VARCHAR(250) NOT NULL,
PRIMARY KEY (`myWords`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB


SQL:



INSERT INTO myWords_table (myWords) VALUES ("word / word"),("word /  word")

Error: Duplicate entry 'word / word' for key 'PRIMARY'


*I also tried Unique Key.
It seems like MYSQL can not handle double Space after /



Can you please help me?*

0 comments:

Post a Comment