SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

 

Forrards Group Database Blog

I`m an SQL Server consultant experienced in areas such as database design, T-SQL advanced programming, database administration and business intelligence. I have a good understanding of a few subject domains, for example, finance, trading, telecoms and insurance. Right now I`m running a small database consultancy and a blog, though I'm also an active stock trader.

Comments

Leave a comment on the original post [www.forrards.com, opens in a new window]

Loading comments...