FirebirdSQL logo
 Procedural SQL (PSQL) StatementsAggregate Functions 

UNICODE_VAL()

Unicode code point from string

Result type

INTEGER

Syntax
UNICODE_VAL (ch)
Table 1. UNICODE_VAL Function Parameter
Parameter Description

ch

A string of the [VAR]CHAR data type or a text BLOB

Returns the Unicode code point (range 0…​0x10FFFF) of the character passed in.

  • If the argument is a string with more than one character, the Unicode code point of the first character is returned.

  • If the argument is an empty string, 0 is returned.

  • If the argument is NULL, NULL is returned.

See also

[fblangref50-scalarfuncs-unicode-char], [fblangref50-scalarfuncs-ascii-val]

UPPER()

Converts a string to uppercase

Result type

(VAR)CHAR, (VAR)BINARY or BLOB

Syntax
UPPER (str)
Table 1. UPPER Function Parameter
Parameter Description

str

An expression of a string type

Returns the uppercase equivalent of the input string.The exact result depends on the character set.With ASCII or NONE for instance, only ASCII characters are uppercased;with character set OCTETS/(VAR)BINARY, the entire string is returned unchanged.