Query: dbix::class::storage::dbi::ado::microsoft_sql_server
OS: debian
Section: 3pm
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server(3pmUser Contributed Perl DocumentatiDBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server(3pm)NAMEDBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server - Support for Microsoft SQL Server via DBD::ADOSYNOPSISThis subclass supports MSSQL server connections via DBD::ADO.DESCRIPTIONThe MSSQL specific functionality is provided by DBIx::Class::Storage::DBI::MSSQL.EXAMPLE DSNdbi:ADO:provider=sqlncli10;server=EEEBOXSQLEXPRESSCAVEATSidentities "_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. truncation bug 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. 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.) fractional seconds Fractional seconds with DBIx::Class::InflateColumn::DateTime are not currently supported, datetimes are truncated at the second.AUTHORSee "AUTHOR" in DBIx::Class and "CONTRIBUTORS" in DBIx::Class.LICENSEYou may distribute this code under the same terms as Perl itself. perl v5.14.2 2011-05-10 DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server(3pm)