Bug 37599 - Increase char limit of borrowers.userid database field
Summary: Increase char limit of borrowers.userid database field
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-08-07 22:01 UTC by Alex Buckley
Modified: 2024-08-08 21:01 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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