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.


© 1992 - OpenLink Software. All rights reserved.

Making Technology Work for You®