SQL function we could use more often — ASCII () function with examples

ASCII is an abbreviation for American Standard Code for Information Interchange, and to make things a bit more clear it is a character encoding standard for electronic communication. It was invented as a 7-bit character set (128 bytes), but as it became common to use 8-bit bytes to store each character in memory, the opportunity for extended 8-bit relatives of ASCII was provided. Also, as communication and computer technology has spread throughout the world, different variations of ASCII were developed to express non-English languages characters.

The first 32 codes of the ASCII table are reserved for unprintable control characters such as backspace, end of the text, escape, vertical or horizontal tab etc. Codes 32 to 127 are common for all other variations of the ASCI table and know as printable characters. There are 95 printable characters in total representing letters (uppercase and lowercase), digits, punctuation marks and a few miscellaneous symbols. The third group known as the extended ASCII codes represents eight-bit or larger encoding sets of additional characters. One of the most used encodings nowadays is Windows-1252 or CP-1252, which is being used by default in the legacy components of Microsoft Windows for the English language and many European languages. It is a single-byte character encoding of the Latin…