---
name: "DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server::Cursor"
section: "3pm"
platform: "linux"
package: "libdbix-class-perl"
version: "0.082844-1"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server::Cursor"
---

# DBIx::Class::Storage::DBI::ADO::Microsoft\_SQL\_Server::Cursor(3pm)

Remove trailing NULLs in binary data and normalize GUIDs for MSSQL over ADO

## NAME

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

## DESCRIPTION

This class is for removing trailing `"NULL"`s 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 `"NULL"`s and GUIDs come back wrapped in braces, the purpose of this class is to remove the `"NULL"`s 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.

## FURTHER QUESTIONS?

Check the list of additional DBIC resources.

## COPYRIGHT AND LICENSE

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.