The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.


DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server::Cursor - Remove trailing NULLs in binary data and normalize GUIDs for MSSQL over ADO


This class is for removing trailing NULLs from binary data and removing braces from GUIDs retrieved from Microsoft SQL Server over ADO.

You probably don't want to be here, see DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server for information on the Microsoft SQL Server driver for ADO and DBIx::Class::Storage::DBI::MSSQL for the Microsoft SQL Server driver base class.

Unfortunately when using DBD::ADO, binary data comes back padded with trailing NULLs and GUIDs come back wrapped in braces, the purpose of this class is to remove the NULLs and braces. DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server sets cursor_class to this class by default. It is overridable via your connect_info.

You can use DBIx::Class::Cursor::Cached safely with this class and not lose the binary data normalizing functionality, ::Cursor::Cached uses the underlying class data for the inner cursor class.


Check the list of additional DBIC resources.


This module is free software copyright by the DBIx::Class (DBIC) authors. You can redistribute it and/or modify it under the same terms as the DBIx::Class library.