Its the greatest city in the South. I'm not so good at recommending tourist stuff to to b/c i was born and raised there and never really do any of that. 2 weeks ago was my first time actually shopping at the Market in like 8 years. But it is definately something you as a tourist should do. The Charleston Museum (meeting st.) is the oldest museum in the US. You can go there to see the Hunley submarine and some other stuff. But the best thing there is the handicapped rail out front

Go to the bars on King, East Bay and Market St. My boys own Johnson's Pub so check it out if you are in the East Bay area (its actually on Cumberland). They usually have live music. If you want to have a good time but would rather have a nice glass of wine then go to The Social on East Bay St. For seafood go to Hank's, Fleets Landing, or The Boathouse. Avoid Hyman's as its just a tourist trap and is not nearly as good these other places. Other great restaurants include S.N.O.B., Virginia's, Rue de Jean, High Cotton, Jestine's, Magnolia's, Carolina's, Hominy Grill etc. The prices/styles of cooking very so just check them out online and see what works for you. If you go to the beach, go to Folly (instead of Isle of Palms/Sullivan's Island). Its more of the local beach and you'll get a better feeling for Charleston.
Idk what else to say. If you have any specific questions just PM me. I'll probably be able to tell you whatever you need to know.
Bookmarks