---
description: >-
  Explore MariaDB Server variables and modes. This section explains how to
  configure global and session variables, and how different SQL modes influence
  database behavior and compatibility.
---

# Variables and Modes

{% content-ref url="variables-and-modes/full-list-of-mariadb-options-system-and-status-variables" %}
[full-list-of-mariadb-options-system-and-status-variables](variables-and-modes/full-list-of-mariadb-options-system-and-status-variables)
{% endcontent-ref %}

{% content-ref url="variables-and-modes/server-status-variables" %}
[server-status-variables](variables-and-modes/server-status-variables)
{% endcontent-ref %}

{% content-ref url="variables-and-modes/server-system-variables" %}
[server-system-variables](variables-and-modes/server-system-variables)
{% endcontent-ref %}

{% content-ref url="variables-and-modes/old-mode" %}
[old-mode](variables-and-modes/old-mode)
{% endcontent-ref %}

{% content-ref url="variables-and-modes/sql-mode" %}
[sql-mode](variables-and-modes/sql-mode)
{% endcontent-ref %}

{% content-ref url="https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/about/compatibility-and-differences/sql_modemssql" %}
[SQL\_MODE=MSSQL](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/about/compatibility-and-differences/sql_modemssql)
{% endcontent-ref %}

{% content-ref url="https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/about/compatibility-and-differences/sql_modeoracle" %}
[SQL\_MODE=ORACLE](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/about/compatibility-and-differences/sql_modeoracle)
{% endcontent-ref %}
