Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212

    Unanswered: Varchar vs NVarchar

    I have tested my ASP codings taking data from varchar tables
    and NVarchar tables.

    Both are able to return readeable chinese characters.

    Its just a matter of how I store it and how I call it out to be displayed.

    Using only varchar, I won't need to put the "N" to denote unicode string for my scripts.

    So what I don't understand is why most people prefer storing chinese characters in Nvarchar ?

    Anybody care to explain the benefits of Nvarchar vs Varchar for my intention ?

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    If you install your database on a server with a different character set, your varchar fields will use the new character set while the nvarchar will still show as chinese characters.

    For international language support, use nchar and nvarchar. Otherwise, use char and varchar because they take up half as much space.

    blindman

Posting Permissions

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