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 readingTag: what is
How BIN() Works in MariaDB
In MariaDB, BIN() is a built in string function that returns a string representation of the binary value of the given longlong (i.e. BIGINT) number.
You provide the longlong number when you call the function.
Continue readingHow SHOW CHARACTER SET Works in MariaDB
In MariaDB, you can use the SHOW CHARACTER SET administrative SQL statement to return all available character sets in MariaDB.
How CHAR() Works in MariaDB
In MariaDB, CHAR() is a built-in string function that returns characters based on their code values.
CHAR() accepts one or more integers. It then returns a string consisting of the characters given by the code values of those integers.
How CHR() Works in MariaDB
In MariaDB, CHR() is a built-in string function that returns a character based on the code values provided as an argument.
How ORD() Works in MariaDB
In MariaDB, ORD() is a built-in string function that returns the numeric character code of the leftmost character of its string argument.
The ORD() function can handle multi-byte characters. This is in contrast to the ASCII() function, which only handles single-byte (8 bit) characters.
How ASCII() Works in MariaDB
In MariaDB, ASCII() is a built-in string function that returns the numeric ASCII value of the leftmost character of its string argument.
The ASCII() function only works on 8 bit characters. To get the code for multi-byte characters, use the ORD() function instead.
MongoDB sort()
In MongoDB, the cursor.sort() method specifies the order in which the query returns matching documents.
The sort() method accepts a document that specifies the field to sort, and the sort order. The sort order can be either 1 for ascending or -1 for descending.
You can also specify { $meta: "textScore" } when doing $text searches, in order to sort by the computed textScore metadata in descending order.
MongoDB $orderBy
In MongoDB, the $orderBy query modifier sorts the results of a query in ascending or descending order.
$orderBy accepts a document that specifies the field to sort, and the sort order. The sort order can be either 1 for ascending or -1 for descending.
$orderBy has been deprecated in the mongo shell since v3.2. Use the cursor.sort() method instead.
MongoDB $sort
In MongoDB, the $sort aggregation pipeline stage sorts all input documents and returns them to the pipeline in sorted order.