Convert HTML text into DB-safe string, by converting some characters as below.
Cannot believe that I do not have this here before now.
Replacing ' with {{$Q$}}
Replacing " with {{$QQ$}}
Replacing \ with {{$BS$}}
Replacing / with {{$FS$}}
Replacing > with {{$GT$}}
Replacing < with {{$LT$}}
Replacing Enter (or
) with {
}
And back
Those two has t be used together everytime we read from or save into DB
Edit 2020-08-07: Added ANma_DB2Str and ANma_Str2DB2
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Bold.codes
Linkedin Login
strHTML
or
strDB
or
strDB
Views 3,149
Downloads 1,174
CodeID
DB ID
