DBIx::C...:Cursor(3)

hey bestie, welcome to the DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server::Cursor page from the User Contributed Perl Documentation πŸ’…βœ¨ yes, that module name is a whole staircase, but we’re here and we’re slaying it.

🌸 NAME 🌸

  • DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server::Cursor β€” Remove trailing NULLs in binary data and normalize GUIDs for MSSQL over ADO 🫢

πŸ’… DESCRIPTION πŸ’…

okay so this class is literally for removing trailing "NULL"s from binary data and removing braces from GUIDs retrieved from Microsoft SQL Server over ADO. no cap.

you probably don’t want to be here β€” and that’s not me being shady, that’s the docs. see DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server for information on the Microsoft SQL Server driver for ADO, and see DBIx::Class::Storage::DBI::MSSQL for the Microsoft SQL Server driver base class 🫢

here’s the unfortunate tea 😭: when using DBD::ADO, binary data comes back padded with trailing "NULL"s and GUIDs come back wrapped in braces. the whole 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 ✨

also, 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. iconic behavior, honestly πŸ’–

🫢 FURTHER QUESTIONS? 🫢

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 πŸ’œ


that’s the whole vibe. source/version/date check for the sign-off: perl v5.42.0, 2025-01-22, and the footer says DBIx::C...:Cursor(3) β€” mwah πŸ’‹πŸŽ€

πŸ“¦ where this page comes from