Home Forums SQL Server 2005 Development Difference between varchar(max) and varchar(8000) RE: Difference between varchar(max) and varchar(8000)

  • February 2, 2009 at 7:56 am

    #936441

    VARCHAR(MAX) uses the normal datapages until the content actually fills 8k of data.

    When overflow happens, data is stored as old TEXT, IMAGE and a pointer is replacing the old content.

    N 56°04'39.16"
    E 12°55'05.25"