sql_identifier_prepare_for_compare


Description:


[ Version ( since = "5.0" ) ]
public string sql_identifier_prepare_for_compare (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 instance of 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 (&lt;part1&gt;."&lt;part2&gt;" for example) WARNING: you may have to <code>include &lt;sql-parser/gda-sql-parser.h&gt;</code>

Parameters:

str

a quoted string

Returns:

str


Namespace: Gda
Package: libgda-6.0