I thought you were asking specifically if that particular lyric referred to a particular place. From a Texan perspective using the word "Caroline" in a geographical sense automatically refers to the Carolinas, North or South. Common knowledge even to a Texan.