Arabic Support in ASP.net application and sql server
-
how to make my web apllication(ASp.net) and sql server support arabic language to insert data in arabic in my DB from my web application... if anyone know the solution,please answer me... :)
-
how to make my web apllication(ASp.net) and sql server support arabic language to insert data in arabic in my DB from my web application... if anyone know the solution,please answer me... :)
Hi Have a look at links shown below , hope it will help: Look at the walkthrough here: http://msdn.microsoft.com/library/d...ingWebForms.asp These quickstart samples also do a good job of showing the basic underlying concepts: http://msdn.microsoft.com/library/d...ocalization.asp You might also find the presentation here useful: http://www.microsoft.com/india/msdn.../downloads.aspx (look for "Building applications with localization in mind")
-
how to make my web apllication(ASp.net) and sql server support arabic language to insert data in arabic in my DB from my web application... if anyone know the solution,please answer me... :)
Hi, Look some solutions for SQL and for ASP.net: In SQL: Data type of field for your table must be nchar, nvarchar or ntext. Exactly data type with 'n' abide unicode informations. When you insert informations in table use N before switch text. For exemple: declare @strMessage nvarchar (4000) select @strMessage = 'insert into TblJournal(JComMessage) values (N''' + @JComMessage + ''')' execute ( @strMessage ) In this case @JComMessage is arabic text. In ASP.net problems generated by usage of arabic text are general solved through encoding and decoding. You can use namespace System.Web and System.Text. System.Web.HttpUtility.UrlEncodeUnicode(); System.Web.HttpUtility.UrlDecode(); System.Text.UTF8Encoding... System.Text.UTF8Encoding.GetEncoding