David Nolan

 Prince Charming is the husband of Snow White, though neither of them remembers this in the cursed Storybrooke, where the character's name is David Nolan ("Charming" is the nickname given to him by Snow White). In his previous life, David is actually the brother of the real prince James who died and was replaced with his twin. Both brothers were born to a poor farm couple who made a deal with Rumpelstiltskin to save their farm; they gave up one son to King George, whose wife could not conceive. After James's death his brother found out the truth and took his place, becoming engaged to Abigail, daughter of King Midas (reluctantly, after his family is threatened by King George) in a deal that unites two kingdoms with Midas giving King George gold in exchange for the prince defeating a dragon. Later, the prince meets and marries Snow White with whom he has a daughter named Emma. In Storybrooke, David is a John Doe with amnesia who meets and falls for Mary Margaret, who is really Snow White, before recovering his memory and working at the Storybrooke Sheriff Department. He later has another child with Snow White named Neal.