Data type for SQL Server for DbType.AnsiStringFixedLength

[beppler]

On DbTypes x SqlServer is documented that the types generated for DbType.AnsiStringFixedLength are the following:

• char(255) if precision is not specified
• char(n) if precision is between 1 and 255
• text if precision is between 256 and 65535
• mediumtext if precision is between 65536 and 16777215

Based on SQL Server Data Type Mappings the type used for AnsiString should be:

• char(255) if precision is not specified (to remain compatible with previous behavior)
• char(n) for precision between 1 and 8000

The mediumtext datatype does not exist on SQL Server text datatype is deprecated and I think that it is not applicable to FixedLength.

So if precision is specified and is not between 1 and 8000 I think that an exception should be raised.

[beppler]

I've created a project fork at https://github.com/mpsinfo/sharpdata that contains this update.

[beppler]

Resolved by #19.