Would you keep the same character sprites and just display the weapons during the battle phase? Would you not display them anywhere but in the inventory? Or would you have a set of each sprite holding each weapon so that they could walk around carrying it?
Clearly some of these choices require more work than others. I'm comparing Pokemon a game where you're using attacks instead of weapons so the sprite is always the same, to something far more complex like Diablo where they've drawn every frame of every character in every possible position with and without each weapon.
Any Ideas?

Thanks,
-Dan