Neoview SQL Reference Manual (R2.4)

CODE_VALUE Function

The CODE_VALUE function returns an unsigned integer (INTEGER UNSIGNED) that is the

code point of the first character in a character value expression that can be associated with one

of the supported character sets. See .

CODE_VALUE is a Neoview SQL extension.

CODE_VALUE(character-value-expression)

_character-set

character-value-expression

is a character string.

Example of CODE_VALUE Function

This function returns 97 as the result:

>>select code_value('abc') from (values(1))x;

(EXPR)

----------

CODE_VALUE Function 343