can somebody help me I don't know what is this its my 1st time using mysql and heidisql I'm trying to create a database but I don't know what is the character set and collation to use and can you please explain me what is this?
You could always install phpMyAdmin if you're not familiar with SQL command codes.
Just a suggestion. :)
phpmyadmin is a godsend. unless your doing something strange and different, utf8 unicode ci is standard.
The defaults will pretty much never give you a problem. Like @Bmckalip said utf8 is pretty much always the default.