there are several way..atleast first search it it asked before already on codeproject..
(
how to store hindi data in sql server 2005[
^])
1) you have to choose datatype nvarchar and use unicode to store hindi data (the good soution) because unicode supported by all machines which have not hindi font as mobile , tablet, many more...