SQL ASCII Function

The ASCII function returns the ASCII code value for a character.

ASCII stands for American Standard Code for Information Interchange.

ASCII is a 7-bit character set used as the standard encoding for modern computers.

Example

#

This example returns the ASCII values for the given characters.

SELECT ASCII('D') AS 'D',
       ASCII('p') AS 'p',   
       ASCII('9') AS '9',   
       ASCII('½') AS '½',
       ASCII('Ø') AS 'Ø'
Result:  1 record
D p 9 ½ Ø
68 112 57 189 216

Syntax

Syntax of the ASCII function.

ASCII(character)

You may also like



Guides


vsn 3.1