SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Aaron West / BASE64 Encode and Decode in T-SQL - optimized / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 23:58:46 GMT20RE: BASE64 Encode and Decode in T-SQL - optimizedhttp://www.sqlservercentral.com/Forums/Topic410316-898-1.aspxRemove whitespace before calling the function. Use SUBSTITUTEIf you uncomment this code it would return null:--IF @encoded_text COLLATE LATIN1_GENERAL_BIN-- LIKE '%[^ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/=]%'-- COLLATE LATIN1_GENERAL_BIN-- RETURN NULLtry: SET @encoded_text = SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( @encoded_text, ' ',''),CHAR(9),''),CHAR(10),''),CHAR(13),'')(Okay so 5 years for me to bother to check the discussion is a bit long. I use Oracle lately...)Wed, 16 Jan 2013 14:05:13 GMTAaron WestRE: BASE64 Encode and Decode in T-SQL - optimizedhttp://www.sqlservercentral.com/Forums/Topic410316-898-1.aspxThanks for this. I nearly used this function.Wed, 14 Apr 2010 23:46:28 GMTZA_CraftyRE: BASE64 Encode and Decode in T-SQL - optimizedhttp://www.sqlservercentral.com/Forums/Topic410316-898-1.aspx:-PThanks!It's very useful for me.Tue, 17 Mar 2009 20:01:27 GMTlyoutRE: BASE64 Encode and Decode in T-SQL - optimizedhttp://www.sqlservercentral.com/Forums/Topic410316-898-1.aspxI came across a bug(?) in this function. I'm using it in my proc to decode the base64 encoded string. My string is this:'This is a really long sentence to see how this thing will crash or if it even will crash I am now at 152 letters and still conting'.It get encoded via an Actionscript function to this:'VGhpcyBpcyBhIHJlYWxseSBsb25nIHNlbnRlbmNlIHRvIHNlZSBob3cgdGhpcyB0aGluZyB3aWxsIGNyYXNoIG9yIGlmIGl0IGV2ZW4gd2lsbCBjcmFzaCBJIGFtIG5vdyBhdCAxNTIgbGV0dGVycyBhbmQgc3RpbGwgY29udGluZy4='What the proc sees is this:This is a really long sentence to see how this thing will ò7&6‚÷"–b—BWfVâv–ÆÂ7&6‚’Òæ÷rBS"ÆWGFW'2P¿nd still conting.For some reason the function bombs at around the 59th place in the string but then picks back up later. Any ideas why? The column is defined as varchar(500) so no insert/update problems there.Thanks.Wed, 12 Nov 2008 11:24:02 GMTdpasseyBASE64 Encode and Decode in T-SQL - optimizedhttp://www.sqlservercentral.com/Forums/Topic410316-898-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Miscellaneous/31520/">BASE64 Encode and Decode in T-SQL - optimized</A>[/B]Sat, 13 Oct 2007 08:57:49 GMTAaron West