Selecting borewell for 6 inch borewell having 235 meter depth

Good day,

I have a 6 inch borewell having depth 235 meter. Planning to use a 5 hp 3 phase pump.
I have seen 4" pumps giving better flow rate than 5" and 6" pumps.
Could anybody share texmo borewell pump performance chart for 5" and 6 inch borewell pumps.
Is there any issue if I use 4 inch pump in 6 inch borewell?

apart from the technical evaluations which is very important, I found getting a local perspective really helped when we were putting in a motor espicially around power and voltageā€¦ so I would not underestimate the power of knowledge that the locals hhave!