In MariaDB, LENGTHB()
is a built-in string function that returns the length of the given string argument, measured in bytes.
How LENGTH() Works in MariaDB
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 readingMariaDB CHARACTER_LENGTH() Explained
In 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.
How CHAR_LENGTH() Works in MariaDB
In MariaDB, CHAR_LENGTH()
is a built-in string function that returns the length of the given string argument, measured in characters.
How CONVERT() Works in MariaDB
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()
.
How CAST() Works in MariaDB
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()
.
How CHARSET() Works in MariaDB
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 readingSet the Character Set and Collation of a Database in MariaDB
You 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).
How the BINARY Operator Works in MariaDB
In MariaDB, the BINARY
operator casts the string following it to a binary string.
The BINARY
operator enables you to do a column comparison byte by byte rather than character by character. This causes the comparison to be case sensitive even if the column isn’t defined as BINARY
or BLOB
. It also means that leading/trailing spaces become significant.
How BIT_LENGTH() Works in MariaDB
In MariaDB, BIT_LENGTH()
is a built in string function that returns the length of the given string argument in bits.
You provide the string as an argument when you call the function.
Continue reading