Actually, it depends on the manufacturer. Most come with only Svideo, but I bought a MSI 5200 yesterday with both. I was surprised.
As for the adapter, most are just doggles that plug into a port that has pins for both svideo (4 pins) and composite (2 pins), so if you look at the port on the card, it'll have 6 pin holes.
Jugs