dbix::class::storage::dbi::sybase::microsoft_sql_server(3pm) [debian man page]

DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server(User Contributed Perl DocumentDBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server(3pm)

NAME

       DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server - Support for Microsoft SQL Server via DBD::Sybase

SYNOPSIS

       This subclass supports MSSQL server connections via DBD::Sybase.

DESCRIPTION

       This driver tries to determine whether your version of DBD::Sybase and supporting libraries (usually FreeTDS) support using placeholders,
       if not the storage will be reblessed to DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server::NoBindVars.

       The MSSQL specific functionality is provided by DBIx::Class::Storage::DBI::MSSQL.

METHODS

   connect_call_datetime_setup
       Used as:

	 on_connect_call => 'datetime_setup'

       In connect_info to set:

	 $dbh->syb_date_fmt('ISO_strict'); # output fmt: 2004-08-21T14:36:48.080Z

       On connection for use with DBIx::Class::InflateColumn::DateTime

       This works for both "DATETIME" and "SMALLDATETIME" columns, although "SMALLDATETIME" columns only have minute precision.

AUTHOR

       See "CONTRIBUTORS" in DBIx::Class.

LICENSE

       You may distribute this code under the same terms as Perl itself.

perl v5.14.2							    2011-05-26	      DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server(3pm)

DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server(3pmUser Contributed Perl DocumentatiDBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server(3pm)

NAME

       DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server - Support for Microsoft SQL Server via DBD::ADO

SYNOPSIS

       This subclass supports MSSQL server connections via DBD::ADO.

DESCRIPTION

       The MSSQL specific functionality is provided by DBIx::Class::Storage::DBI::MSSQL.

EXAMPLE DSN

	 dbi:ADO:provider=sqlncli10;server=EEEBOXSQLEXPRESS

CAVEATS

   identities
       "_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.

AUTHOR

       See "AUTHOR" in DBIx::Class and "CONTRIBUTORS" in DBIx::Class.

LICENSE

       You 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)