Case Sensitive collation in MySQL

by

According to MySQL Manual http://dev.mysql.com/doc/refman/5.0/en/charset-mysql.html you should be able to set collation to _cs for case sensitivity. You can get a list of _cs collations by executing SHOW COLLATION WHERE COLLATION LIKE "%_cs" query

After a little research:

Apparently there are no utf8_*_cs in MySQL (yet). If you need case sensitive collation for utf8 fields, you should use utf8_bin. This will mess up ORDER BY, but this can be fixed by ORDER BY column COLLATE utf8_general_ci

Source: http://forums.mysql.com/read.php?103,19380,200971#msg-200971 and http://forums.mysql.com/read.php?103,156527,198794#msg-198794

More Related Contents:

  1. Which DB technology is sued to solve the following search issue? [closed]
  2. MyISAM versus InnoDB [closed]
  3. How to select the nth row in a SQL database table?
  4. Compare two MySQL databases [closed]
  5. How should I resolve –secure-file-priv in MySQL?
  6. What does character set and collation mean exactly?
  7. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  8. Storing image in database directly or as base64 data?
  9. Implementation of Levenshtein distance for mysql/fuzzy search?
  10. Does MySQL ignore null values on unique constraints?
  11. What’s the difference between MyISAM and InnoDB? [duplicate]
  12. Is there an ANSI SQL alternative to the MYSQL LIMIT keyword?
  13. In SQL, is it OK for two tables to refer to each other?
  14. Error renaming a column in MySQL
  15. Mysql database sync between two databases
  16. How to increase MySQL connections(max_connections)?
  17. Does mysql have the equivalent of Oracle’s “analytic functions”?
  18. MySql views performance [closed]
  19. MySQL: LAST_INSERT_ID() returns 0
  20. How does MySQL Auto Increment work?
  21. Calculating a Moving Average MySQL?
  22. How to get size of mysql database?
  23. What is the difference between SQL and MySQL? [closed]
  24. mysql Failed to read auto-increment value from storage engine
  25. WooCommerce: Finding the products in database
  26. Is it unreasonable to assign a MySQL database to each user on my site?
  27. Are there any functions in MySQL like dense_rank() and row_number() like Oracle?
  28. Create a new database with MySQL Workbench
  29. Optimistic locking in MySQL
  30. How to search and replace all instances of a string within a database?

Leave a Comment