We are working on a asp.net project. We are bulding this site for a news paper. Which will be multilingual and show the content as per user choice of culture.
So, can any one tell me the details how can I do it if user select hindi or urdu link then the content will show in urdu or hindi language and text.
Now what I want to do is there is a grid which is showing data from DataBase.
I am using SQL Server 2005 for storing data.
I have Inserted value in Database (in Arabic text) coloumn type is NVARCHAR. After Inserting value it is showing ????????? . And when I want to display it in grid view it is showing ?????.
So Can you please tell me how can I save data in Arabic Text in to DataBase. What I have to do with tables to acheive this.
Actually I want to know How to save data in Table in Urdu or Arabic font or text. What setting should I do with database table to acheive this.
Because in Table I save Name='اردو' but after inserting in table it is showing like '????' and when I am trying to fetch this record record is coming
like'???' instead of 'اردو'.
reyazalam
Member
1 Points
7 Posts
How to built multilingual website
Aug 26, 2008 09:33 AM|LINK
Hi,
We are working on a asp.net project. We are bulding this site for a news paper. Which will be multilingual and show the content as per user choice of culture.
So, can any one tell me the details how can I do it if user select hindi or urdu link then the content will show in urdu or hindi language and text.
Thanks in Advance
G0ggy
Participant
1081 Points
299 Posts
Re: How to built multilingual website
Aug 26, 2008 10:36 AM|LINK
Massive subject, have a start here:
http://quickstarts.asp.net/QuickStartv20/aspnet/doc/localization/default.aspx
Remember to mark as answer the solution which helped you.
vivek_iit
All-Star
17778 Points
3189 Posts
MVP
Re: How to built multilingual website
Aug 26, 2008 04:22 PM|LINK
Hi,
Refer this article for localization:
http://www.codeproject.com/KB/aspnet/localizationByVivekTakur.aspx
Hope this helps,
Vivek
Communifire: Social Networking and Business Collaboration Platform
reyazalam
Member
1 Points
7 Posts
Re: How to built multilingual website
Aug 28, 2008 11:53 AM|LINK
Hi,
Thank you ............. for ur reply.
Now I am able to do it from Resource file.
Now what I want to do is there is a grid which is showing data from DataBase.
I am using SQL Server 2005 for storing data.
I have Inserted value in Database (in Arabic text) coloumn type is NVARCHAR. After Inserting value it is showing ????????? . And when I want to display it in grid view it is showing ?????.
So Can you please tell me how can I save data in Arabic Text in to DataBase. What I have to do with tables to acheive this.
Thanks again
vivek_iit
All-Star
17778 Points
3189 Posts
MVP
Re: How to built multilingual website
Aug 29, 2008 03:27 AM|LINK
Save the page as UTF-8 encoded using Sa As ->Encoding->UTF8
Communifire: Social Networking and Business Collaboration Platform
reyazalam
Member
1 Points
7 Posts
Re: How to built multilingual website
Aug 29, 2008 09:23 AM|LINK
Thanks for ur answer-
Actually I want to know How to save data in Table in Urdu or Arabic font or text. What setting should I do with database table to acheive this.
Because in Table I save Name='اردو' but after inserting in table it is showing like '????' and when I am trying to fetch this record record is coming like'???' instead of 'اردو'.
Please help me how to solve it.
Thank you
DeepeshBhati...
Member
536 Points
106 Posts
Re: How to built multilingual website
Sep 04, 2008 07:06 AM|LINK
Check out collation properties of SQl Server