1DBIx::Class::Storage::DUBsDIeB:rI:xAC:Do:OnC:tl:raMisibscu:rt:oeSsdtoofPrtea_rgSleQ:LD:_oDScBeuIrm:ve:enArtD(aO3t:)i:oMnicrosoft_SQL_Server(3)
2
3
4
6 DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server - Support for
7 Microsoft SQL Server via DBD::ADO
8
10 This subclass supports MSSQL server connections via DBD::ADO.
11
13 The MSSQL specific functionality is provided by
14 DBIx::Class::Storage::DBI::MSSQL.
15
16 CAVEATS
17 identities
18
19 "_identity_method" is set to @@identity, as "SCOPE_IDENTITY()" doesn't
20 work with DBD::ADO. See "IMPLEMENTATION NOTES" in
21 DBIx::Class::Storage::DBI::MSSQL for caveats regarding this.
22
23 truncation bug
24
25 There is a bug with MSSQL ADO providers where data gets truncated based
26 on the size of the bind sizes in the first prepare call:
27
28 <https://rt.cpan.org/Ticket/Display.html?id=52048>
29
30 The "ado_size" workaround is used (see "ADO Providers" in DBD::ADO)
31 with the approximate maximum size of the data_type of the bound column,
32 or 8000 (maximum VARCHAR size) if the data_type is not available.
33
34 This code is incomplete and may be buggy. Particularly, "VARCHAR(MAX)"
35 is not supported yet. The data_type list for other DBs is also
36 incomplete. Please report problems (and send patches.)
37
39 See "CONTRIBUTORS" in DBIx::Class.
40
42 You may distribute this code under the same terms as Perl itself.
43
44
45
46perl v5.12.0 DBIx::Class2:0:1S0t-o0r5a-g1e2::DBI::ADO::Microsoft_SQL_Server(3)