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:



An example of a string conversion to Base64:





An example of reverse conversion:



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.


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

Loading comments...