Articles

For side-by-side syntax and behavior across database engines, browse the cross-database SQL comparison guides.

How the COERCIBILITY() function works in Mariadb?

The COERCIBILITY() function is a system function that returns the collation coercibility value of a given string argument.

How the DISJOINT() function works in Mariadb?

The ST_DISJOINT() function in MariaDB is used to determine whether two spatial objects are disjoint or not.

How the COALESCE() function works in Mariadb?

The COALESCE() function is a conditional function that returns the first non-NULL value from a list of values.

How the DIMENSION() function works in Mariadb?

The DIMENSION() function is a built-in function in Mariadb that returns the dimension of a geometry value.

How the DES_ENCRYPT() function works in Mariadb?

The DES_ENCRYPT() function is a string function that encrypts a string using the Data Encryption Standard (DES) algorithm, which is a symmetric-key block cipher.

How to Install SQLite on Ubuntu 22: A Step-by-Step Tutorial

Install the sqlite3 command-line shell on Ubuntu 22 with APT, verify the installed SQLite version, and open an interactive prompt to manage database files.

How the CHR() function works in Mariadb?

The MariaDB CHR() function is used to convert an ASCII code integer to its corresponding character.

How the DES_DECRYPT() function works in Mariadb?

The DES_DECRYPT() function is a string function that decrypts a string that was encrypted using the DES_ENCRYPT() function.

How to Install SQLite on Ubuntu 20.04 (Legacy Guide)

Install SQLite on Ubuntu 20.04 for an existing system. Standard security maintenance ended in 2025; Ubuntu Pro ESM may cover it through 2030.

How the CHARSET() function works in Mariadb?

The CHARSET() function is a string function that returns the name of the character set of a given string. The character set of a string determines how the string is stored, displayed, and compared.