My product is currently works only for English language. I want it work with other different native characters like Japanese, Korena, Chinese etc.
I am veryyyyyyy much new to this area. Please help me how i can move forward.
Let me add to what the others have told you it is the complexity of the problem that led to a new Unicode standard proposed for all of the above languages and the right to left languages. If your application is Winform it is much easier because Vista and newer operating system makes it easy to change language. Webform remains complicated and require manual work. SQL Server uses UCS-2 but if you use Nvarchar in SQL Server 2008 your data is the same bytes with UTF16 which is an unsigned int 16. You can download the PDF from the link below read through it and then define your needs and post again this time include platform, RDBMS version and other relevant details.
http://www.knowprose.com/fosslocal
Kind regards,
Gift Peddie