youjiageng1/doc-exports
1
0
Fork 0
forked from laiweijian4/doc-exports
Code Pull Requests Activity
doc-exports/docs/dli/sqlreference/dli_spark_ascii.html
Su, Xiaomeng 76a5b1ee83 dli_sqlreference_20240227 
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Su, Xiaomeng <suxiaomeng1@huawei.com>
Co-committed-by: Su, Xiaomeng <suxiaomeng1@huawei.com>
2024-03-27 22:02:33 +00:00

5.5 KiB
Raw Permalink Blame History

ascii

This function is used to return the ASCII code of the first character in str.

Syntax

ascii(string <str>)

Parameters

Table 1 Parameter

Parameter

Mandatory

Type

Description

str

Yes

STRING

If the value is of the BIGINT, DOUBLE, DECIMAL, or DATETIME type, the value is automatically converted to the STRING type for calculation.

Example: ABC

Return Values

The return value is of the BIGINT type.

  • If the value of str is not of the STRING, BIGINT, DOUBLE, DECIMAL, or DATETIME type, an error is reported.
  • If the value of str is NULL, NULL is returned.

Example Code

  • Returns the ASCII code of the first character in string ABC. An example command is as follows:
    The value 97 is returned.
    select ascii('ABC');
  • The value of the input parameter is NULL. An example command is as follows:
    The value NULL is returned.
    select ascii(null);
Parent topic: String Functions