Case sensitive column

ozzii · #1 (**permalink**) 06-19-07, 10:20

Is there any way to make a varchar or text mysql table column case sensative?

r937 · #2 (**permalink**) 06-19-07, 10:36

quote from the manual under the section Case Sensitivity in Searches --

"If you want a column always to be treated in case-sensitive fashion,
declare it as BINARY. See section CREATE TABLE Syntax."

brijneetclarion · #3 (**permalink**) 06-23-07, 05:09

You can also use the keyword BINARY for making case sensitive comparisions

e.g. SELECT * FROM TABLE WHERE BINARY colname='what ever text'

aschk · #4 (**permalink**) 06-24-07, 18:05

Check out charsets and collations. Binary is not necessarily the answer.