Prepare string for database insertion. Fixes quotes and other special characters.
Namespace: Wiker.WIDatabaseAssembly:
Syntax
C# |
---|
public static string PrepareSQLVariable( string data ) |
Visual Basic |
---|
Public Shared Function PrepareSQLVariable ( _ data As String _ ) As String |
Visual C++ |
---|
public: static String^ PrepareSQLVariable( String^ data ) |
Parameters
- data
- Type: System..::..String
Data string to fix
Return Value
string
Remarks
If SETTINGS.PrepareSQLVariable == false, data will be unchanged.
Removes redundant wildcards from the end of each word in the search phrase and
Replaces | With |
---|---|
"'" | "''" |
"^" | "^^" |
"%" | "^%" |
"'_" | "^_" |
"[" | "^[" |
"]" | "^]" |
"*" | "%" |
"?" | "_" |