SQL Server has no knowledge about the fonts. What it knows is only the data type and the encoding of the text.
What you can do is define a columns of
NVARCHAR [
^]type.
What it means is that NVARCHAR can store
Unicode [
^]data. Thus, it's upto you if you want to store the text in Hindi, English or even japanese.