Reference Manual Volumes 1 - 4 (Online Only)

uhighsurr

Description

Returns 1 if the Unicode value at position start is the high half of a surrogate pair (which should appear first in the pair). Returns 0 otherwise.

uhighsurr(uchar_expr, start)

uchar_expr

is a character-type column name, variable, or constant expression of unichar, or univarchar type.

start

specifies the character position to investigate.

uhighsurr, a string function, allows you to write explicit code for surrogate handling. Specifically, if a substring starts on a Unicode character where uhighsurr() is true, you need to extract a substring of at least 2 Unicode values. (substr will not extract half of a surrogate pair.)
If uchar_expr is NULL, returns NULL.
For general information about string functions, see "String functions".

SQL92 - Compliance level: Transact-SQL extension.

Any user can execute uhighsurr.


	Expand Search