The SOPHIE Consortium started, in November 2006, several programs of exoplanet search and characterization in the Northern hemiphere with the spectrograph SOPHIE based on the 1.93m telescope at the Observatoire de Haute-Provence. We present here the latest SOPHIE results which include new exoplanets, studies of transiting planets through Rossiter-McLaughlin effect, characterizations of stellar activity of planet-host star and observation of the Earth as a transiting planet.