SQL unique varchar case sensitivity question

by

Looks like mysql is case insensitive by default:

You probably need to create the column with a case sensitive collation (e.g. utf8_bin):

CREATE TABLE WORDS (
    ID BIGINT AUTO_INCREMENT, 
    WORD VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL UNIQUE, 
    PRIMARY KEY(ID)
);

More Related Contents:

  1. How can I make SQL case sensitive string comparison on MySQL?
  2. How do you force mysql LIKE to be case sensitive? [duplicate]
  3. INSERT INTO SELECT statement with more columns which is not in another table
  4. SQL Print the name of all Employees together with the name of their supervisor
  5. MySQL how to fill missing dates in range?
  6. Left Outer Join doesn’t return all rows from my left table?
  7. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  8. Are table names in MySQL case sensitive?
  9. How to split the name string in mysql?
  10. MySQL: Large VARCHAR vs. TEXT?
  11. MySQL offset infinite rows
  12. Can a foreign key reference a non-unique index?
  13. How to set a maximum execution time for a mysql query?
  14. Get the latest date from grouped MySQL data
  15. SQL keys, MUL vs PRI vs UNI
  16. How to copy a row and insert in same table with a autoincrement field in MySQL?
  17. MySQL Error 1264: out of range value for column
  18. How to change the default port of mysql from 3306 to 3360
  19. Like Case Sensitive in MySQL
  20. How to move columns in a MySQL table?
  21. Is it possible to reference one column as multiple foreign keys?
  22. Split a string and loop through values in MySQL stored procedure
  23. how to cast the hexadecimal to varchar(datetime)?
  24. MySQL Select Query – Get only first 10 characters of a value
  25. Most efficient way to store IP Address in MySQL [duplicate]
  26. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  27. Postgres LEFT JOIN with WHERE condition
  28. mysql select id and name from other table and join query
  29. #1060 – Duplicate column name ‘id’
  30. Update multiple rows with multiple ‘where’ clauses for each individual row

Leave a Comment