Blog Post

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

 

Original post (opens in new tab)
View comments in original post (opens in new tab)

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating