Case Sensitive usernames - or not
Results 1 to 2 of 2

Thread: Case Sensitive usernames - or not

  1. #1
    phpMaster
    Join Date
    Jun 2005
    Location
    Europe
    Posts
    3,014

    Case Sensitive usernames - or not

    I wonder what is best to use
    - case sensitive usernames
    - case insensitive usernames.

    Both are possible.
    If I use MySQL with charset utf8, there will be default collate utf8_general_ci,
    in what 'ci' stands for Case Insensitive.

    But I can make table be COLLATE utf8_bin,
    which will make the contents of th table or a column be Case Sensitive.

    By default is case insensitive is used in database.
    So 'admin' will be treated as equal to 'Admin'.

    I wonder if there is any good reason to use the case sensitive option?
    Apache-2.4.28 (Win64) / PHP-7.1.10 / MySQL-5.7.19 / phpMyAdmin-4.7.4

  2. #2
    Pedantic Curmudgeon Weedpacket's Avatar
    Join Date
    Aug 2002
    Location
    General Systems Vehicle "Running Gear"
    Posts
    22,564
    This has come up in the past. See some discussion here:
    http://board.phpbuilder.com/showthre...1#post10428115

    As for the collation of the table, such implementation details shouldn't be driving the decision.
    THERE IS AS YET INSUFFICIENT DATA FOR A MEANINGFUL ANSWER
    FAQs! FAQs! FAQs! Most forums have them!
    Search - Debugging 101 - Collected Solutions - General Guidelines - Getting help at all

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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