XLR vs RCA

What are the differences? Is one better than the other? Always? Sometimes? The CD player I'm purchasing has the facility for XLR, but I was told by my friend who heard the player, that it sounded better with single ended. His feeling is single ended usually wins in coherence and musicality. Feedback, as always, would be appreciated. Thanks in advance,
warren