Skip to main content
ExLibris

Knowledge Assistant

BETA
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Case sensitivity of Patron IDs

    Case sensitivity of Patron IDs

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    When entering a patron ID in the borrower box of the Circulation module (Loan or Patron tabs), the input is forced to be upper case, no matter what is actually typed at the keyboard. If the ID we are attempting to match on is stored in lower case (character data), then there is no match. Is there a way to change how this input box handles the input data? Is Aleph assuming that all IDs are upper case to begin with? Could an ID be used that contained both upper and lower case characters? When we try to use this ID to log on to the Web, it stays in lowercase, but it doesn't find a match. Our type 03 ID (net id) is a campus assigned alphanumeric ID used by the campus LDAP system and is used widely across campus. The netid is normally treated as lower case by campus systems and pretty much all other applications that make use of this ID.

    Resolution:
    Yes, ALEPH is assuming that IDs are in uppercase. This SQL can be used to change lowercase type '03' IDs to upper: SQL> update z308 set z308_rec_key = upper (z308_rec_key) where z308_rec_key like '03%'; If the user enters the ID in uppercase, it will match. If the user enters the ID in lowercase, the system will uppercase it and it will match.

    Additional Information

    case sensitivity, patron ID


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Carets in columns 9 and 10 of edit_field.lng
      • Cash 'by sublibrary' sort crashes circ client: "fetched column value is NULL"
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 16.02
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved