The CHAR and VARCHAR types are not case sensitive by default , but may be declared as BINARY to make them case sensitive. ENUM , SET , and TEXT columns are not case sensitive. BLOB columns are case sensitive. (See the table in Recipe 4.1.)
Read moreHow do I make my character not case sensitive?
you can use Character. toLowerCase or Character. toUpperCase to make all to lower case or upper case and compare it.
Read moreHow do I make something optional in regex?
Optional Items
Read moreIs regex case sensitive?
By default, the comparison of an input string with any literal characters in a regular expression pattern is case sensitive , white space in a regular expression pattern is interpreted as literal white-space characters, and capturing groups in a regular expression are named implicitly as well as explicitly.
Read more