LudicrouslyMad
I regret to inform you(Or most of you) that usually it depends on the race, or clan, given that the story is anywhere near fantasy. Their personality should have nothing to do with their names otherwise it sounds too predictable.
ie- Use the name Bella, put her in a short skirt and give her blonde hair. This is what all of your readers expected. However, give Bella to a butch type of woman with muscles and brown hair that can chop off a persons head with only the side of her hand... Now that would be an interesting twist.
For a drunkard, use any name. Use any nickname. It doesn't matter. But their race... Now that should say something. Would you have an orc with the name "Cassy"? Or an elf with the name "Bagruhm?" Probably not, but then one can only hope.
A name can often be used from a clan as well. If they are in a spacific clan, of course you are going to try to fit in that name with the clan. You might not have "Filly, Killy, Bill, and Lilly" but you might just have "Lorel, Liel, Gardenia, Rosemary" just for the whole garden-flower-plant effect, if that's what the clan is based on.
Now don't take my word for it, authors screw up names all the time, make it predictable, or just simply silly enough to be stupid. Whatever floats your boat.
Okay, first off, I didn't say it was based on the character's personality. I said to give me a brief description (age, background, location, etc...). And second of all, not everybody writes about fantasy and uses "clans" to group characters. A name has to fit, its going to be with the character for a while. A character has to be like a person you could meet in real life, and you have to comfortable with a name, like an article of clothigng. While this analogy is as shitty as they get, its the best I could come up with.