Please find below steps to store and retrieve hindi text.
1) Choose utf8 character set and utf8_general_ci collation.
2) Whenever you want to save and retrieve the data you need to set the characterset as follows.
//To set the char set
mysql_set_charset('utf8');
//To select hindi data
mysql_query("SELECT * FROM ....");
// To insert hindi data
mysql_query("INSERT INTO ....");
Before you display hindi content in your browser set content type of that page using meta tag.
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />