Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 11-06-2009
Member
 
Join Date: Aug 2008
Posts: 31
nvarchar vs text in Asp.net

Can anyone know what is the difference between nvarchar and text ? I think nvarchar is used to store unicode data, which is used to store multilingual data in our database tables.
Reply With Quote
  #2  
Old 11-06-2009
Member
 
Join Date: Dec 2008
Posts: 69
Re: nvarchar vs text in Asp.net

Variable-length Unicode character data of n characters. n must be a value from 1 through 4,000. Storage size, in bytes, is two times the number of characters entered. The data entered can be 0 characters in length. The SQL-92 synonyms for nvarchar are national char varying and national character varying.
Reply With Quote
  #3  
Old 11-06-2009
Member
 
Join Date: Dec 2008
Posts: 40
Re: nvarchar vs text in Asp.net

When n is not specified in a data definition or variable declaration statement, the default length is 1. When n is not specified with the CAST function, the default length is 30.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "nvarchar vs text in Asp.net"
Thread Thread Starter Forum Replies Last Post
TEXT message icon not showing text messages in BlackBerry curve 8520 Tabita Portable Devices 5 28-02-2011 08:23 PM
BlackBerry Torch TEXT message icon not showing text messages rOSAMOND Portable Devices 8 17-10-2010 01:04 AM
How to change the size of text with text messages on the Samsung Impression Calusa Portable Devices 6 07-10-2010 02:29 PM
How to recover lost text from text area in Google Chrome? Corwinn Technology & Internet 5 10-03-2010 12:56 PM
Differences between rich text and plain text format Kamran Windows Software 4 19-06-2009 09:00 PM


All times are GMT +5.5. The time now is 03:49 AM.