NAME

DBIO::MSSQL::Storage::Sybase::NoBindVars - Support for Microsoft SQL Server via DBD::Sybase without placeholders

VERSION

version 0.900007

DESCRIPTION

Storage driver for Microsoft SQL Server accessed via DBD::Sybase when your combination of DBD::Sybase and libraries (most likely FreeTDS) does not support ? style placeholders. DBIO::MSSQL::Storage::Sybase reblesses the storage into this class automatically on connect when no placeholder support is detected.

This driver uses DBIO::Storage::DBI::NoBindVars as a base, so bind variables are interpolated (properly quoted) into the SQL query itself instead of being passed as placeholders. Because that renders prepared statement caching useless, caching is explicitly disabled.

In all other respects it behaves as DBIO::MSSQL::Storage::Sybase.

  • populate in void context inserts row by row, in one transaction. Core's fast path prepares one statement and executes it once per row, which values written into the statement cannot do; it throws "Unable to invoke fast-path insert without storage placeholder support" for every data set. A row the server refuses rolls the data set back.

  • The values are core's literal: nothing here refuses a character beyond ASCII ("STRINGS BEYOND ASCII" in DBIO::MSSQL::Storage::Sybase), writes a binary value or rewrites an empty string -- there are no binds to look at. An empty string for an integer column is written without quotes (VALUES ( )) and refused by the server, Msg 102, loudly and without a row (the literal is core's).

SEE ALSO

AUTHOR

DBIO & DBIx::Class Authors

COPYRIGHT AND LICENSE

Copyright (C) 2026 DBIO Authors Portions Copyright (C) 2005-2025 DBIx::Class Authors Based on DBIx::Class, heavily modified.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.