Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asifbhura
Posting Yak Master
165 Posts |
 Posted - 2008-09-22 : 03:08:30
|
| hiI have one table in my DB named TblNewswhich contains newsid,news_title,news_detail,news_source,news_date etc.now, Some time i am having news in Arabic as well.So, My question is I should create a news table for arabic news or I should add filed name in TblNews table such as ar_news_title,ar_news_details.Which will be suitable for me & faster to search.bcoz if arabic language selected in my web application then it must display arabic news. or is there any other way |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-22 : 03:24:11
|
| you can store both the language values in same field provided your datatype is of unicode type (nvarchar,ntext,..) and also your code page supports arabic. If your web application has to deal them seperately you could set a flag which indicates if language is arabic or english and then using it select only reqd language value for processing. |
 |
|
|
asifbhura
Posting Yak Master
165 Posts |
Posted - 2008-09-22 : 03:25:40
|
| Thank you very much |
|
|
|
|
|
|
how to design table if there are......