Nine people have died in a shooting at a historic African-American church in Charleston in the US state of South Carolina, officials say.