Name
casemode_strcmp, fix_identifier_case — identifier case-mode helpers
Synopsis
integer casemode_strcmp(
|
in str1 varchar, |
in str2 varchar); |
varchar fix_identifier_case(
|
in ident varchar); |
Description
casemode_strcmp compares two strings using the
server's configured identifier case-comparison rule (case-sensitive vs.
case-insensitive). It returns a negative integer, zero, or a positive
integer when the first string is less than, equal to, or greater than the
second under that rule. Returns NULL if either argument is NULL.
fix_identifier_case applies the server's identifier
case-folding policy (typically upper-casing unquoted identifiers) to
ident and returns the normalized name. Use it when
constructing schema names in SQL strings that must match the way Virtuoso
stores them internally.