moras da naznacis da je polje case sensitive: COLLATE latin1_general_cs
Kôd:
CREATE TABLE `test` (
`testString` VARCHAR( 128 ) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL
) TYPE = MYISAM
neki insert:
Kôd:
INSERT INTO `test` ( `testString` )
VALUES ('dpt' ), ('DPT');
Kôd:
mysql> select * from test;
+------------+
| testString |
+------------+
| dpt |
| DPT |
+------------+
2 rows in set (0.00 sec)
Kôd:
mysql> select * from test where testString='dpt';
+------------+
| testString |
+------------+
| dpt |
+------------+
1 row in set (0.00 sec)
kao sto vidis, radi.
prilikom autentifikacije za passworde koristi md5 - nema boli glava.