Menu

Articles

How the UCASE() function works in Mariadb?

The UCASE() function in MariaDB is used to convert a string to uppercase.

How the PolygonFromWKB() function works in Mariadb?

The PolygonFromWKB() function is a spatial function in Mariadb that creates a Polygon object from a well-known binary (WKB) representation.

How the TRUNCATE() function works in Mariadb?

The TRUNCATE() function in MariaDB is used to truncate a number to a specified number of decimal places.

MariaDB PASSWORD() Function

Learn what MariaDB PASSWORD() does, why it is limited to MariaDB server account authentication, and why it is not an application password hash.

How the OVERLAPS() function works in Mariadb?

The OVERLAPS() function is a spatial function in Mariadb that returns 1 or 0 to indicate whether two geometries spatially overlap.

How the PolygonFromText() function works in Mariadb?

The PolygonFromText() function is a spatial function in Mariadb that creates a Polygon object from a well-known text (WKT) representation.

How the TRIM() function works in Mariadb?

The TRIM() function in MariaDB is used to remove leading and trailing spaces or specified characters from a string.

How the ORD() function works in Mariadb?

The ORD() function is a built-in function in Mariadb that returns the numeric ASCII code of the first character of a string value.

How the POLYGON() function works in Mariadb?

The POLYGON() function is a spatial function in Mariadb that creates a Polygon object from a list of coordinates.

How the TOUCHES() function works in Mariadb?

The TOUCHES() function in MariaDB is a spatial function used to test whether two geometries touch each other.