Bug 37599

Summary: Increase char limit of borrowers.userid database field
Product: Koha Reporter: Alex Buckley <alexbuckley>
Component: DatabaseAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low    
Version: Main   
Hardware: All   
OS: All   
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Alex Buckley 2024-08-07 22:01:56 UTC
It would be nice if the Koha database field borrowers.userid had a higher char limit than 75 characters.

Increasingly, libraries are using organisational emails as a userid for single-sign-on.

These email addresses cannot always be stored in the Koha borrowers.email field 

So the borrowers.userid has to be used for storing it. However, if an email address is long then it may not fit within the current 75 character limit of borrowers.userid.
Comment 1 Katrin Fischer 2024-08-08 07:46:35 UTC
We also have this use case as for authentication it needs to be in userid. We haven't run into the character limit (yet), but it seems a good idea to increase it.

Please keep deleted_borrowers and borrower_modifications in mind :)
Comment 2 Alex Buckley 2024-08-08 21:01:02 UTC
(In reply to Katrin Fischer from comment #1)
> We also have this use case as for authentication it needs to be in userid.
> We haven't run into the character limit (yet), but it seems a good idea to
> increase it.
> 
> Please keep deleted_borrowers and borrower_modifications in mind :)

thanks for noting this Katrin, much appreciated!

Yes, that is a good point that this change would need to happen on deleted_borrowers and borrower_modifications as well