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)
committerJulian Maurice <julian.maurice@biblibre.com>
Fri, 26 Feb 2016 13:20:03 +0000 (14:20 +0100)
commit619060799d5b89c22fe83dfecc229b84a638b0da
treef5369481f6c4591445ed8273cd17441a8c0b05b3
parent1e682f6ad939e34207b3e34ad1aead7715216938
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
(cherry picked from commit 203659ee60b25614eecd01f69e23e3be57952707)
Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>
C4/SIP/ILS.pm