Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Case sensitive data

Status
Not open for further replies.
fayna

fayna

Programmer
Jan 14, 2002
35
ES
Is there any configuration option that lets MySQL distinguish different cases in tables' data?
Thanks
 
Sort by date Sort by votes
Quoted from here:

Code: 
Use the BINARY keyword on each column you want to be case sensitive.

    ie. COLUMN_X CHAR(128) BINARY NOT NULL

Then it will use case sensitive searches and selects. It is important to note that even if a column doesn't include the BINARY keyword, all data is still stored in the correct case.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Marclem
  • Locked
  • Question
Get users Last Login Data 1
Replies
13
Views
1K
Marclem
Marclem
jyothi12389
  • Locked
  • Question
create a schedule and MYSQL loading csv data to table
Replies
0
Views
100
jyothi12389
jyothi12389
Samus Aran
  • Locked
  • Question
Looking for specific data using SELECT
Replies
0
Views
124
Samus Aran
Samus Aran
Narny
  • Locked
  • Question
Need to append some text to existing data using concat
Replies
1
Views
161
SkipVought
S
FoxAll
  • Locked
  • Question
Lots of data !
Replies
0
Views
91
FoxAll
FoxAll

Part and Inventory Search

Sponsor

Back
Top