Data type for SQL Server for DbType.AnsiString - Githubissues

SharpTools / sharpdata

An awesome ORM for querying and modifying databases

MIT License

11 stars 6 forks source link

Data type for SQL Server for DbType.AnsiString #8

Closed beppler closed 5 years ago

beppler commented 6 years ago

On DbTypes x SqlServer is documented that the types generated for DbType.AnsiString 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:

varchar(255) if precision is not specified (to remain compatible with previous behavior)
varchar(n) for precision between 1 and 8000
varchar(max) for precision bigger than 8000

The mediumtext datatype does not exist on SQL Server and text datatype is deprecated, but should be used if SQL Server is version 2005 or older.

beppler commented 6 years ago

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