In MariaDB, CONCAT() is a built-in string function that performs a string concatenation on its arguments. It returns the string that results from concatenating its arguments.
Concatenation is the operation of joining two or more strings end-to-end.
CONCAT() accepts one or more arguments, all of which are returned as a single concatenated string.
In MariaDB, OCTET_LENGTH() is a built-in string function that returns the length of the given string argument, measured in octets (bytes).
OCTET_LENGTH() is a synonym for LENGTHB().
It’s also a synonym for LENGTH() when not in Oracle mode (LENGTH() behaves differently in Oracle mode).
In MariaDB, LENGTHB() is a built-in string function that returns the length of the given string argument, measured in bytes.
In MariaDB, LENGTH() is a built-in string function that returns the length of the given string argument.
When in default mode, the length of the string is measured in bytes. But when in Oracle mode, it’s measured in characters.
Continue readingIn MariaDB, CHARACTER_LENGTH() is a built-in string function that returns the length of the given string argument, measured in characters.
CHARACTER_LENGTH() is actually a synonym for CHAR_LENGTH(), so you can use either.
In MariaDB, CHAR_LENGTH() is a built-in string function that returns the length of the given string argument, measured in characters.
In MariaDB, CONVERT() is a built in function that converts a value to another data type. It takes a value of one type and returns a value of the specified type.
You provide the value as an argument when you call the function, as well as the type that you’d like it converted to.
CONVERT() is similar to CAST().
In MariaDB, CAST() is a built in function that converts a value to another data type. It takes a value of one type and returns a value of the specified type.
You provide the value as an argument when you call the function, as well as the type that you’d like it converted to.
CAST() works similar to CONVERT().
In MariaDB, CHARSET() is a secondary built in function that returns the character set of a given string.
We provide the string when we call the function.
Continue readingYou can specify the character set and collation at various levels in MariaDB. You can specify them at the connection level, the server level, the database level, the table level, and the column level.
You can also specify a collation in your queries so that it overrides any collation that has been previously specified at the aforementioned levels.
To set the character set and collation at the database level, use the CREATE DATABASE statement or ALTER DATABASE statement (depending on whether you’re creating the database or modifying it).