Lasso Soft Inc. > Home

[ string->encodeSQL92 ]

Method

[string->encodeSQL92] encodes illegal characters in SQL string literals by escaping them with a single quote mark. Helps to prevent SQL injection attacks and ensures that SQL statements only contain valid characters. This method can be used to encode values for JDBC, SQLite and most other SQL-compliant data sources, but not MySQL.

  • Syntax
'String Value'->encodeSQL92
Examples
  • Beginner

To encode illegal characters in SQL string literals:

Use the [string->encodeSQL92] method. The following example escapes illegal characters with a single quote mark.

Code

"Rhino's horn"->encodesql92

Result

Rhino''s horn
Related Entries
  • Category
Methods
encode_break 
string->append 
string->asBytes 
string->asString 
string->beginsWith 
string->chardigitvalue 
string->charname 
string->chartype 
string->compare 
string->contains 
string->decodehtml 
string->decodexml 
string->digit 
string->eachCharacter 
string->eachMatch 
string->eachWordBreak 
string->encodehtml 
string->encodehtmltoxml 
string->encodeSQL 
string->encodeSQL92 
string->encodexml 
string->endsWith 
string->equals 
string->find 
string->findlast 
string->foldcase 
string->forEachCharacter 
string->forEachLineBreak 
string->forEachMatch 
string->forEachWordBreak 
string->get 
string->getnumericvalue 
string->getpropertyvalue 
string->hasbinaryproperty 
string->integer 
string->isalnum 
string->isalpha 
string->isbase 
string->isblank 
string->iscntrl 
string->isdigit 
string->isgraph 
string->islower 
string->isprint 
string->ispunct 
string->isspace 
string->istitle 
string->isUAlphabetic 
string->isULowercase 
string->isupper 
string->isUUppercase 
string->isUWhiteSpace 
string->isWhitespace 
string->isxdigit 
string->keys 
string->length 
string->lowercase 
string->merge 
string->normalize 
string->oncompare 
string->padLeading 
string->padTrailing 
string->remove 
string->removeleading 
string->removetrailing 
string->replace 
string->reverse 
string->size 
string->split 
string->sub 
string->substring 
string->titlecase 
string->tolower 
string->totitle 
string->toupper 
string->trim 
string->unescape 
string->uppercase 
string->values 
String_Concatenate 
String_EndsWith 
String_Extract 
String_FindPosition 
string_findregexp 
String_Insert 
String_IsAlpha 
String_IsAlphaNumeric 
String_IsDigit 
String_IsHexdigit 
String_IsLower 
string_IsNumeric 
String_IsPunctuation 
String_IsSpace 
String_IsUpper 
String_Length 
String_LowerCase 
String_Remove 
String_RemoveLeading 
String_RemoveTrailing 
string_replace 
String_ReplaceRegExp 
String_ToDecimal 
String_ToInteger 
String_UpperCase 
String_ValidCharset
Types
string

Recent Comments

No Comments found

Please note that periodically LassoSoft will go through the notes and may incorporate information from them into the documentation. Any submission here gives LassoSoft a non-exclusive license and will be made available in various formats to the Lasso community.

Search

Your Favourites
Log in to retrieve favourites
Recently Viewed
Contributors

Steve Piercy

LassoSoft Inc. > Home

 

 

©LassoSoft Inc 2015 | Web Development by Treefrog Inc | Privacy | Legal terms and Shipping | Contact LassoSoft