Moving to Charleston?

Anyone here from Charleston? My partner and I are considering relocating from Florida to Charleston and a wondering a couple of things.

First, what would be a good area to live? We would probably rent an apartment at least at first and we do have two small dogs.

Second, are there areas of Charleston that are more gay friendly than others?