ORD()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
Returns the code value of the leftmost character in the string argument.
USAGE
ORD(string)
Argument Name | Description |
|---|---|
| The string to evaluate |
DETAILS
ORD() is a string function that returns the code value of the leftmost character in the string argument.
A multi-byte character is interpreted as a single character, unlike ASCII() (which cannot handle higher numbered characters).
A single-byte character returns the same value as ASCII().
A NULL is returned if the argument is NULL.
EXAMPLES
SELECT ORD('1'), ORD('abc'), ORD('a');
+----------+------------+----------+
| ORD('1') | ORD('abc') | ORD('a') |
+----------+------------+----------+
| 49 | 97 | 97 |
+----------+------------+----------+