Charleston is beautiful for vacation, but I don't think it is a good place to raise family. The children's museum is very small and shabby. You do not see many Asians there.
For diversification, Greenville is much better choice because of BMW, GE turbine, and Michelin.