how can i save telugu text into db useing stored procedure

Question

hi all how can i save telugu text into db useing stored procedure parameters from mvc c#. i am geting ??????s when i try to save the data . please someone help me.

Nitin · Answer

Hi Mounika Well I could not see the images you have posted but glad to know you were able to resolve the issue. :)

mounika mounika · Answer

Thanks nitin for your help I was able to solve the Issue. If our table Columns datatype is Nvarchar then we don't need to prefix any 'N' Character to our stored Procedure Parameters. I have added my tables Image below enter image description here Here is the stored Procedure which i have used: CREATE PROCEDURE [dbo].[usp_UpdateSubCategoryDetails] -- Add the parameters for the stored procedure here @SubCategoryID INT @SCDetailsHeading NVARCHAR(300) @SCDetailsDescription NVARCHAR(3000) @IMAGE NVARCHAR(100) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here INSERT INTO tblSubCategoryDetails(SubCategoryIDSCDetailsHeadingSCDetailsDescription[Image]IsActive) VALUES(@SubCategoryID@SCDetailsHeading@SCDetailsDescription@IMAGE1) SELECT SubCategoryIDSCDetailsHeadingSCDetailsDescription[Image] FROM tblSubCategoryDetails WHERE IsActive =1 END OUTPUT: 1 ???? ??????: 40 ???? ??? ??? ???? ??????: 40 ???? ??? ??? ../images/FilmyImages/heroine_raashi_khanna-1920x1080.jpg

Nitin · Answer

Try this script with your application. This should work. Use the following in your cs file: var cmd = new SqlCommand(your_sp_name sqlConn); var sp_param = new SqlParameter(@sp_variable SqlDbType.NVarChar); sp_param.Value = unicode_chars_string_value; cmd.Parameters.Add(sp_param); - See more at: http://www.discuzfeed.com/code/llprhtrs-how-to-implicitly-add-the-n-in-the-prefix-for-nvarchar.html#sthash.s4RfXBOX.dpuf

mounika mounika · Answer

hi nitin can you remove the N in insert statement and exucute it will be getting ?????? istead of text . so we have to pass N as parameter how can we pass it. How to prefix N in the Insert statement of the stored Procedure so that when we enter the regional text ???? will not be displayed

Nitin · Answer

Use this script. I have modified this and is working ALTER PROCEDURE [dbo].[usp_telugu] -- Add the parameters for the stored procedure here @SCDetailsHeading NVARCHAR(300) @SCDetailsDescription NVARCHAR(3000) @IMAGE NVARCHAR(100) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here INSERT INTO TELUGU(TitleDescription[Image]) VALUES(N'' + @SCDetailsHeading + ''N'' + @SCDetailsDescription + ''@IMAGE) SELECT TitleDescription[Image] FROM TELUGU END EXEC [usp_telugu] N'??'N'??''\Images	emplatemo_image_02.jpg'

mounika mounika · Answer

hi nithin this is what we required exactly Normal Insert statement INSERT INTO Telugu (Title Description [Image]) VALUES (N'????????.. ???????? ???? ?????? ?????? ' N'????????.. ???????? ???? ?????? ??????' '\Images	emplatemo_image_02.jpg') How should we use N prefix for the insert statement in the below Stored Procedure so that it will insert telugu text in DB. EXEC [usp_telugu] '????????.. ???????? ???? PINAL ?????? ?????? ''????????.. ???????? ???? PINAL ?????? ??????''\Images	emplatemo_image_02.jpg' CREATE PROCEDURE [dbo].[usp_telugu] -- Add the parameters for the stored procedure here @SCDetailsHeading NVARCHAR(300) @SCDetailsDescription NVARCHAR(3000) @IMAGE NVARCHAR(100) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here INSERT INTO TELUGU(TitleDescription[Image]) VALUES(@SCDetailsHeading@SCDetailsDescription@IMAGE) SELECT TitleDescription[Image] FROM TELUGU END

Nitin · Answer

Use the following approach

Avikshith Aradhya · Answer

If column data type is NVARCHAR then you can insert any Unicode value and it will be stored successfully but if your column data type was different while inserting data the those unicode values will be stored as '??????'.

Nitin · Answer

Use the following approach: Declare @Name NVARCHAR(MAX) SET @NAME=N'??' INSERT INTO CityMaster values(@Name) Let me know if any issues

mounika mounika · Answer

Thanks for Your Suggestions. how do i do that using a stored procedure parameter. how to prefix N to a stored Proceure Parameter.

Nitin · Answer

Hi You are getting this because you probably have not used NVARCHAR as the datatype for that column. Also while saving you should prefix N before the column value. Make the column as NVARCHAR(MAX). Use the query like: Insert into Student(Name) Values(N'Some text') Refer this link for more information. http://sqlhints.com/2013/12/28/why-the-prefix-n-is-used-for-literal-strings-in-sql-server/

mounika mounika · Answer

how to save the telugu text from frontend to db using the ado.net entity frame work

mounika mounika · Answer

If you are having soure code please send it

mounika mounika · Answer

i tried that but i am not getting

Avikshith Aradhya · Answer

Create the Table column Data type as NVarchar into which you need to insert data.