char vs nchar

  • I am designing a new database,

    what are the pros and cons of using the nchar data types as opposed to char data types?

    for character fields

    this will be the database for a new Dot Net WinFrom application

    Thanks

  • n type fields (nchar, nvarchar, ntext) are unicode type, are twice as many bytes to store the same number of characters. So only use if you need to store international characters.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply