Prepare string for database insertion. Fixes quotes and other special characters.

Namespace: Wiker.WIDatabase
Assembly: 

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

 

ReplacesWith
"'" "''"
"^" "^^"
"%" "^%"
"'_" "^_"
"[" "^["
"]" "^]"
"*" "%"
"?" "_"

See Also