Char(39) in SQL table

One of many ways to go around the issue of char 39 in SQL database

CodeFunctionName
What is this?

Public

Tested

Original Work
You know SQL has some issues when using the char 39, that is a single quote or '
There are lots of tricks to go around that
One of them is actually converting that into char 146, which is ’
Or char 96, which is `


char(39) ' can be converted to char(146) ’ to avoid conflict in DB
char(39) ' can be converted to char(96) ` to avoid conflict in DB

Views 1,707

Downloads 575

CodeID
DB ID