Results 1 to 3 of 3

Thread: nvarchar vs text in Asp.net

  1. #1
    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.

  2. #2
    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.

  3. #3
    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.

Similar Threads

  1. Replies: 5
    Last Post: 28-02-2011, 08:23 PM
  2. BlackBerry Torch TEXT message icon not showing text messages
    By rOSAMOND in forum Portable Devices
    Replies: 8
    Last Post: 17-10-2010, 01:04 AM
  3. Replies: 6
    Last Post: 07-10-2010, 02:29 PM
  4. How to recover lost text from text area in Google Chrome?
    By Corwinn in forum Technology & Internet
    Replies: 5
    Last Post: 10-03-2010, 12:56 PM
  5. Differences between rich text and plain text format
    By Kamran in forum Windows Software
    Replies: 4
    Last Post: 19-06-2009, 09:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,715,025,839.23420 seconds with 17 queries