how can i save telugu text into db useing stored procedure

mounika mounika

10y2.2k.NET

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.

15 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin10y ago
Hi Mounika,
Well I could not see the images you have posted but glad to know you were able to resolve the issue. :)
mounika mounika10y ago
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(SubCategoryID,SCDetailsHeading,SCDetailsDescription,[Image],IsActive)
VALUES(@SubCategoryID,@SCDetailsHeading,@SCDetailsDescription,@IMAGE,1)
SELECT SubCategoryID,SCDetailsHeading,SCDetailsDescription,[Image] FROM tblSubCategoryDetails
WHERE IsActive =1
END
OUTPUT: 1 ???? ??????: 40 ???? ??? ??? ???? ??????: 40 ???? ??? ??? ../images/FilmyImages/heroine_raashi_khanna-1920x1080.jpg
Nitin10y ago
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 mounika10y ago
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
Nitin10y ago
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(Title,Description,[Image])
VALUES(N'' + @SCDetailsHeading + '',N'' + @SCDetailsDescription + '',@IMAGE)
SELECT Title,Description,[Image] FROM TELUGU
END
EXEC [usp_telugu] N'??',N'??','\Images\templatemo_image_02.jpg'
mounika mounika10y ago
hi nithin
this is what we required exactly
Normal Insert statement
INSERT INTO Telugu (Title, Description, [Image])
VALUES (N'????????.. ???????? ???? ?????? ?????? ', N'????????.. ???????? ???? ?????? ??????', '\Images\templatemo_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\templatemo_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(Title,Description,[Image])
VALUES(@SCDetailsHeading,@SCDetailsDescription,@IMAGE)
SELECT Title,Description,[Image] FROM TELUGU
END
Nitin10y ago
Use the following approach
Avikshith Aradhya10y ago
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 '??????'.
Nitin10y ago
Use the following approach:
Declare @Name NVARCHAR(MAX)
SET @NAME=N'??'
INSERT INTO CityMaster values(@Name)
Let me know if any issues
mounika mounika10y ago
Thanks for Your Suggestions.
how do i do that using a stored procedure parameter.
how to prefix N to a stored Proceure Parameter.
Nitin10y ago
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 mounika10y ago
how to save the telugu text from frontend to db using the ado.net entity frame work
mounika mounika10y ago
If you are having soure code please send it
mounika mounika10y ago
i tried that but i am not getting
Avikshith Aradhya10y ago
Create the Table column Data type as "NVarchar" into which you need to insert data.