This is a nice sword. It's the best weapon to give a starting Fighter, Thief, or Red Mage.
The Rapier has the same name in the Japanese version. A rapier is a slender, 2-edged sword with a cupped hilt. It's the kind of sword you might see pirates using. As far as I know, rapiers do not appear in any later FFs.