Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2007
    Posts
    212

    Unanswered: Case sensitive column

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

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    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."
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    May 2007
    Posts
    4
    You can also use the keyword BINARY for making case sensitive comparisions

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

  4. #4
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    Check out charsets and collations. Binary is not necessarily the answer.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •