အခုလေးတင်မှ စဉ်းစားမိတာလေးပါ။ ချက်ချင်းအဖြေကို ရှာလိုက်တော့တွေ့တယ်။ Microsoft SQL server 2005 မှာ ရုရှား text တွေ save လို့ ရ မရ ပါ။ အဖြေက ရပါတယ်။ unicode Datatype ကိုအသုံးပြုပြီး သိမ်းရမှာ ဖြစ်ပါတယ်။ ပုံမှာကြည့်ပါ။ ပုံမှန်သိမ်းနေကြ varchar ကို nvarchar အစားထိုးလိုက်ရမှာ ဖြစ်ပါတယ်။
The difference is that nvarchar is used to store unicode data, which is used to store multilingual data in your database tables. Other languages have an extended set of character codes that need to be saved and this datatype allows for this extension. If your database will not be storing multilingual data you should use the varchar datatype instead. The reason for this is that nvarchar takes twice as much space as varchar, this is because of the need to store the extended character codes for other languages
Differences between varchar and nvarchar in SQL Server
By Serdar Yegulalp
Rating: -4.34- (out of 5)
The broad range of data types in SQL Server can sometimes throw people through a loop, especially when the data types seem to be highly interchangeable. Two in particular that constantly spark questions are VARCHAR and NVARCHAR: what's the difference between the two, and how important is the difference?
VARCHAR is an abbreviation for variable-length character string. It's a string of text characters that can be as large as the page size for the database table holding the column in question. The size for a table page is 8,196 bytes, and no one row in a table can be more than 8,060 characters. This in turn limits the maximum size of a VARCHAR to 8,000 bytes.
The "N" in NVARCHAR means uNicode. Essentially, NVARCHAR is nothing more than a VARCHAR that supports two-byte characters. The most common use for this sort of thing is to store character data that is a mixture of English and non-English symbols — in my case, English and Japanese.
MORE INFO ==> http://www.dotnetspider.com/forum/33336-Difference-Between-varchar-nvarchar.aspx and http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1266201,00.html
Storing multiple languages in MSSQL server 2005
Thursday, January 07, 2010
min that thant
Posted in
sqlserver
Subscribe to:
Post Comments (Atom)

No Response to "Storing multiple languages in MSSQL server 2005"
Post a Comment