DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server - Support for Microsoft SQL Server via DBD::ADO
This subclass supports MSSQL server connections via DBD::ADO.
The MSSQL specific functionality is provided by DBIx::Class::Storage::DBI::MSSQL.
_identity_method is set to @@identity, as SCOPE_IDENTITY() doesn't work with DBD::ADO. See "IMPLEMENTATION NOTES" in DBIx::Class::Storage::DBI::MSSQL for caveats regarding this.
_identity_method
@@identity
SCOPE_IDENTITY()
There is a bug with MSSQL ADO providers where data gets truncated based on the size of the bind sizes in the first prepare call:
https://rt.cpan.org/Ticket/Display.html?id=52048
The ado_size workaround is used (see "ADO Providers" in DBD::ADO) with the approximate maximum size of the data_type of the bound column, or 8000 (maximum VARCHAR size) if the data_type is not available.
ado_size
This code is incomplete and may be buggy. Particularly, VARCHAR(MAX) is not supported yet. The data_type list for other DBs is also incomplete. Please report problems (and send patches.)
VARCHAR(MAX)
See "CONTRIBUTORS" in DBIx::Class.
You may distribute this code under the same terms as Perl itself.
To install DBIx::Class, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::Class
CPAN shell
perl -MCPAN -e shell install DBIx::Class
For more information on module installation, please visit the detailed CPAN module installation guide.