DBIx::C...I::MSSQL(3)

Hey bestie 💖 welcome to the User Contributed Perl Documentation page for DBIx::Class::Schema::Loader::DBI::MSSQL — yes, the whole long icon name. Grab a boba, we're doing MSSQL.

🌸 NAME 🌸

DBIx::Class::Schema::Loader::DBI::MSSQL — DBIx::Class::Schema::Loader::DBI MSSQL Implementation.

✨ DESCRIPTION ✨

This is the base driver for Microsoft SQL Server, bestie. It's used by DBIx::Class::Schema::Loader::DBI::Sybase::Microsoft_SQL_Server for support via DBD::Sybase, and by DBIx::Class::Schema::Loader::DBI::ODBC::Microsoft_SQL_Server for support via DBD::ODBC. Slay.

For usage info, see DBIx::Class::Schema::Loader and DBIx::Class::Schema::Loader::Base. Periodt.

🦋 CASE SENSITIVITY 🦋

Okay so most MSSQL databases use "CI" (case-insensitive) collation. For this reason, generated column names are lower-cased, because that makes them easier to work with in DBIx::Class. Highkey iconic.

We attempt to detect the database collation at startup for any database included in db_schema, and set the column lowercasing behavior accordingly, because lower-cased column names do not work on case-sensitive databases. Ngl, that's important.

To manually control case-sensitive mode, put:

preserve_case => 1|0

in your Loader options.

See preserve_case.

NOTE: this option used to be called case_sensitive_collation, but has been renamed to a more generic option. So if you see the old name, that's why, iykyk.

👀 SEE ALSO 👀

Go give these icons a look:

• DBIx::Class::Schema::Loader::DBI::Sybase::Microsoft_SQL_Server
• DBIx::Class::Schema::Loader::DBI::ODBC::Microsoft_SQL_Server
• DBIx::Class::Schema::Loader
• DBIx::Class::Schema::Loader::Base
• DBIx::Class::Schema::Loader::DBI

🫶 AUTHORS 🫶

See "AUTHORS" in DBIx::Class::Schema::Loader.

💖 LICENSE 💖

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. Literally.

---

🎀 Cute sign-off: perl v5.42.0 · 2025-07-25 · DBIx::C...I::MSSQL(3) — bye bestie, go slay 💅✨