Table of Contents

Property VarCharCastSize

Namespace
YndigoBlue.Velocity.Data.Teradata
Assembly
YndigoBlue.Velocity.dll

VarCharCastSize

Gets or sets the maximum VARCHAR size for CLOB and geospatial columns when cast to VARCHAR.

public int VarCharCastSize { get; set; }

Property Value

int

Remarks

Teradata has a maximum VARCHAR size of 32,000 characters. When importing, exporting, or searching CLOB and geospatial data, this setting controls how many characters are preserved. Data exceeding this size is truncated.

Impact on Operations:

  • CLOB Import/Export: CLOBs larger than this size are truncated to this many characters.
  • Geospatial WKT: Well-Known Text representations of complex geometries may exceed this size. Truncation can corrupt geometry data.
  • Full-Text Search: Combined with FullTextSearchClobs=false, only the first N characters are indexed.

Constraint: Maximum value is 32,000 (Teradata VARCHAR limit). Attempting to set higher values will be clamped to this limit.