sql_variant similar to text ?

[Bontebok]

Hello All,

Is the column size of the sql_variant type fixed, or does it vary for the subtype stored within it?

Thanks,
Bontebok

 

[JayKusch]

Varies. This supports values of diffrent datatypes.

Thanks

J. Kusch

 

[Bontebok]

If that is the case, why does it not support a subtype of text? It seems like sql_variant is similar to text except having also a subtype. Which would mean to me that sql_variant should be able to hold a 'text' subtype.

That indicates to me that there must be a maximum size for sql_variant, which may be the largest subtype possible (for example 8000 bytes).

And if that is the case, is the record size for each sql_variant datatype fixed or variable?

Bontebok