hi...
I want to store Multilanguage like Marathi, Hindi, Urdu etc in the database.
when I store these languages, in the Database it shows ????????????????..
I have given the datatype as Nvarchar(MAX).
plzzzz help...
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Vilas GitePosted Jul 2, 2011, 7:55 AM
please refer below links in this article author seonarayan describe well.
http://www.dotnetfunda.com/articles/article1412-how-to-save-and-retrieve-regional-languages-data-from-the-database-.aspx
----------------------------------------------------------------------------------------------------
If this reply hepls your post…then "MARK AS ANSWER"!
Vilas GitePosted Jul 7, 2011, 6:43 AM
Ancy RajuPosted Jul 7, 2011, 5:08 AM
Ancy RajuPosted Jul 2, 2011, 8:25 AM
ALTER PROCEDURE [dbo].[cAddNewsText]
@News ntext,
@ArticleID INT
AS
INSERT INTO News1
(
News, news_id
)
VALUES
(
@News, @ArticleID
)
if (newsletter.News != null) {
using (DbCommand command = wrapper.GetStoredProcCommand("cAddNewsText")) {
wrapper.AddInParameter(command, "News", DbType.String, newsletter.News);
wrapper.AddInParameter(command, "ArticleID", DbType.Int64, newsletter.News_Id);
wrapper.ExecuteNonQuery(command);
}
}
how to i make changes accordingly as I can see multilanguages in my database
Ancy RajuPosted Jul 2, 2011, 7:52 AM
I am working in C# Visual studio 2010 and sql server 2008
I have a html Text Editor, in which i copy paste language like Marathi like (?????? ?? ??? ???? ???????? )
But when i check into my Database sql server 2008 the Text in it appers like ????????????????????? this..
what is the solution to this prob..
Krishna GaradPosted Jul 2, 2011, 7:52 AM
Mayur GujrathiPosted Jul 2, 2011, 7:41 AM
i think there is no provision for storing other lang words in database but you can show in front end
for what i mean to say follow this blog
http://www.c-sharpcorner.com/Blogs/4645/using-other-language-tham-english-in-dot-net-wibdows-applica.aspx