All rules
GCI0050WarnData Integrity

SQL Column Truncation Risk

Detects short nvarchar(N) or varchar(N) column definitions that may silently truncate data when real-world values exceed the column width.

Why this rule exists

varchar(50) for an email is fine until the first user with a long address. Silent truncation produces data corruption that is impossible to recover after the fact.

Code example

Triggers the rule
+ Email nvarchar(50) NOT NULL,
Passes the rule
+ Email nvarchar(320) NOT NULL,  -- RFC 5321 max

Configuration

Disable or adjust the severity of this rule in .gauntletci.json:

{
  "rules": {
    "GCI0050": { "enabled": true, "severity": "Warn" }
  }
}

See Configuration for the full schema.

Related rules

Implemented in src/GauntletCI.Core/Rules/Implementations/GCI0050_*.cs.

About the author

Eric Cogen -- Founder, GauntletCI

Twenty years as a senior technical consultant building and modernizing enterprise platforms across .NET, AWS, serverless, microservices, and AI-driven systems.