Likely it is because Koha is expecting an 4 character value, it is not wise to modify the table directly, is there a reason you need a 5 character branch code? Riley Childs Senior Charlotte United Christian Academy Library Services Administrator IT Services (704) 497-2086 rileychilds.net @rowdychildren ________________________________ From: Manoj Soni<mailto:m9jiihmr@gmail.com> Sent: 9/21/2014 5:28 PM To: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> Subject: [Koha] problem in OPAC search Dear Alll In koha database, using xampp, items table, in field homebranch, which had varchar (4), I made it to varchar(5) , , Then I changed the data in homebranch field, For example it was ABCD and now it is ABCDE but in the search in OPAC, advanced search., If I find by ABCDE, it does not find any thing It says, no results found items.homebranch=ABCDE in the backend, it shows all the data with ABCDE in homebranch field in items table. Also I changed branch code in branch table from ABCD to ABCDE Where should be the problem Thanks and Regards Manoj _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha