sqlIdentifierPrepareForCompare
fn
string sqlIdentifierPrepareForCompare(string str)Prepares str to be compared:
<itemizedlist> <listitem><para>if surrounded by double quotes or single quotes, then just remove the quotes</para></listitem> <listitem><para>otherwise convert to lower case</para></listitem> </itemizedlist>The quoted string:
<itemizedlist> <listitem><para>must start and finish with the same single or double quotes character</para></listitem> <listitem><para>can contain the delimiter character (the single or double quotes) in the string if every instanceof it is preceeded with a backslash character or with the delimiter character itself</para></listitem>
</itemizedlist>This function is normally used only by database provider's implementation.
WARNING: str must NOT be a composed identifier (<part1>."<part2>" for example)
Parameters
str | a quoted string |
Returns
str