Results 1 to 2 of 2

Thread: change row size

  1. #1
    Join Date
    Jan 2002
    Location
    Villamalea (Spain)
    Posts
    4

    Talking Unanswered: change row size

    Hi everybody!!

    I have a table with some nvarchar columns. When I try to put the size I can't to put it greater than 4000.
    How can i change the row size?

    Thanks!!

  2. #2
    Join Date
    Jan 2002
    Posts
    12
    That's the limit for that data type. Internally SQL Server uses 2*n bytes to store it. If you want to go up to 8000 bytes and don't need to use unicode character you should switch to varchar.

Posting Permissions

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