Bug 15479 Make ILS cardnumber comparison case insensitive
authorColin Campbell <colin.campbell@ptfs-europe.com>
Wed, 6 Jan 2016 12:56:24 +0000 (12:56 +0000)
committerBrendan Gallagher <brendan@bywatersolutions.com>
Tue, 23 Feb 2016 23:19:57 +0000 (23:19 +0000)
commit203659ee60b25614eecd01f69e23e3be57952707
tree081d48ebb39e6ff151cd2acdf05482dd07724858
parent53a081278d505b76efbd7c08dbe7d45649779740
Bug 15479 Make ILS cardnumber comparison case insensitive

The borrowers table is defined COLLATE=utf8_unicode_ci which means
that cardnumbers may be saved in either lowercase or uppercase and
these are considered equivalent.
The server was performing a case sensitive comparison between
the incoming patron identifier and that retrieved from the db
As a result some renewals were rejected as being on loan to
another borrower if the stored cardnumber differed in case.

Make code comparison comply with db.

Signed-off-by: Mark Tompsett <mtompset@hotmail.com>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Brendan Gallagher brendan@bywatersolutions.com
C4/SIP/ILS.pm