How to convert to Base64 and backwards via T-SQL

,

I want to share my way to convert a string to  Base64 and back. Let me note that presented method is not the fastest, but it has one important advantage – it works OOB, without CLR functions. We need a test database and a table to use as an example:

base64_1

 

An example of a string conversion to Base64:

base64_2

 

base64_3

 

An example of reverse conversion:

base64_4

 

Rate

Share

Share

Rate