Wearing nappies in school

My son is Wearing nappies in school and Hi my son is almost 9 .At the moment I am changing his sheets every morning as his nappies are not holding the wee. I was wonder if anybody knows of any nappies that hold well? I’ve tried all the shop bought ones with no luck. Tia.