in reply to Checking MySql for capital letters
MySQL is not case sensative on searches.Yes, that's the default option. But you can change that depending on the character set and/or the search operators:
Case Sensitivity in Searches: By default, MySQL searches are not case sensitive. If you want to make this search case sensitive, make sure that one of the operands has a case sensitive or binary collation. For example:
col_name COLLATE latin1_general_cs LIKE 'a%' col_name LIKE 'a%' COLLATE latin1_general_cs col_name COLLATE latin1_bin LIKE 'a%' col_name LIKE 'a%' COLLATE latin1_bin
|
|---|