Row overflow and fixed lenght columns

• SQLEngine

  SSCommitted

  Points: 1633

  More actions

  January 13, 2009 at 7:30 am

  #125578

  I am reading that the row overflow applies only to varchar data, not the fixed data. The fixed data is never stored off-row. But what if the char column is 9000 caracters and can not be stored in-row?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  January 13, 2009 at 7:43 am

  #925882

  The char column cannot be 9000 bytes. You define the char column. It can be up to 8000 bytes.

  If you try to put more in, it is truncated.

• noeld

  SSC Guru

  Points: 96590

  More actions

  January 13, 2009 at 10:05 am

  #926045

  SQL Server does not even let the creation script succeed for char(9000)

  
  * Noel