Skip to main content

ORD

If the leftmost character is not a multibyte character, ORD() returns the same value as the ASCII() function.

If the leftmost character of the string str is a multibyte character, returns the code for that character, calculated from the numeric values of its constituent bytes using this formula:

  (1st byte code)
+ (2nd byte code * 256)
+ (3rd byte code * 256^2) ...

Syntax​

ORD(<str>)

Arguments​

ArgumentsDescription
<str>The string.

Return Type​

BIGINT

Examples​

SELECT ORD('2')
+--------+
| ORD(2) |
+--------+
|     50 |
+--------+
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today