markrendle/Simple.Data — Issue #114: Incorrect max length reported by Sql Server for certain columns
Author: richardhopton
Created: 2011-11-05 00:01:20+00:00
State: open

The fix for 113 involved using the size of the column along with the data type etc. Unfortunalety this highlighted the following:-
IMAGE, TEXT & NTEXT are reported as having a max length of 16, when in fact they can support 2GB of data.
NVARCHAR & NCHAR are reported as having a max length of twice their actual length.