Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New Coder
    Join Date
    Sep 2005
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    difference between datatypes in sqlserver7.0

    hi all,

    i have one doubt regarding to sql server7.0 data types.

    what is the difference between varchar and nvarchar.

    thank you in advance.

  • #2
    Regular Coder
    Join Date
    Jun 2005
    Posts
    804
    Thanks
    0
    Thanked 0 Times in 0 Posts
    NVARCHAR stores data in Unicode. You only get half the space of a regular VARCHAR, because you're using 2 bytes per character, but you can properly store characters that need 2 bytes.

  • #3
    New Coder
    Join Date
    Sep 2005
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    difference between datatypes

    thank you sir,


    means the functionality is same. both are for same purpose, both will allow numbers and characters. am i right sir??

    thanks alot.

    shree

  • #4
    Regular Coder
    Join Date
    Jun 2005
    Posts
    804
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yes, but NVARCHAR (and the other N types) also allows you to properly store 2-byte Unicode characters, like Greek, Turkish, etc. letters.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •