A while back, I received a requirement to save Hindi numbers in our database.
It took some research and here’s how I solved it:
If your character-set is UTF8 then you can save Hindi numbers in varchar2 column type.
If your character-set is AR8MSWIN1256 or AR8ISO8859P6, then you can’t save Hindi numbers in varchar2 columns. You only can save them in nvarchar columns. In this case your national character-set (UTF16 or UTF8) would come in play.
Most likely you won’t be able to type Hindi numbers in SQLPlus, Toad, etc…, instead you can use unistr function to insert and query back the data.
Here is quick example to demonstrate how to insert and select numbers 123:
Insert into hindi_table (col1) values (unistr (‘\0661\0662\0663’));
Select col1 from hindi_table where col1 = unistr (‘\0661\0662\0663’);
Remember either varchar2/UTF8 character-set or nvarchar2/(UTF16 or UTF8) national character-set
Senior Oracle DBA