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 |
|
vijaypothireddy
Starting Member
1 Post |
 Posted - 2006-04-07 : 06:16:51
|
| 1 > should i use nachar or char ?? i know nchar is used for UNICODE.my website is pure asp.net and english local.so can i use char????.wat is the performance degrade if i use nchar??? |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-04-07 : 06:41:18
|
| I would avoid N variants of string datatypes if you don't need them. It doubles the storage requirement, and thus you get less records/page, and thus more disk effort to retrieve your data (and only half as much stuff in Cache too!).Only nagging doubt in my mind is if your code forces implicit casting to N-datatype for some reason, then the cost of Casting may outweigh the cost of extra disk access.Kristen |
 |
|
|
|
|
|
new babier table design