I recently visited Charlotte and had a great time in an area called NoDa, I think it's North of Davidson. It's a very artsy area with good cafe's, galleries and live music.
Also, Discovery Place is a fantastic way to spend an afternoon - it's the science museum in Uptown.
And, South Park Mall is a great way to spend an afternoon if you're into shopping. (They have a Nordstroms with an amazing shoe department!).
Good luck with your move!