Char(39) in SQL table

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


Public

Tested

My Own 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 767 Downloads 195

SQL Learning Materials
ANmarAmdeen
711
Attachments
Revisions

v2.0