convert varchar(max) column data

I have a column in table which stores the actual signature from the singature pad. In the table it is stored as varchar(max) datatype and sample data looks like below. Below data is the actual signature of the person.

CREATE TABLE #test

([Signature] VARCHAR(MAX))

INSERT INTO #test

SELECT '/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAMCAgMCAgMDAwMEAwMEBQgFBQQEBQoHBwYIDAoMDAsKCwsNDhIQDQ4RDgsLEBYQERMUFRUVDA8XGBYUGBIUFRT/2wBDAQMEBAUEBQkFBQkUDQsNFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBT/wAARCAA8AKIDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD9U6KKKACiiigAooooAKKKKACiiigAooooAKKK+dvix+2x4U8GeJ5PBPgfS9Q+LXxJ5A8NeFQJRbMDgm6uOY7dQfvE5K91A5oA+iGYIpZiFUDJJ6AV8z/EP9ubw7beJZ/Bfwm0K/8AjT8QI/lfTfDbD7DZHON11ekGKJQeDgtg8HbXNL+zV8Wv2lmF58fvGP8Awj3hOXDD4aeCJ2ht2X+5e3gO+bj7yIduRlWHSvpj4efDPwp8JvDUHh/wd4fsPDmjwfdtdPhEascY3MRy7HuzEk9yaAPmiD9k/wCIv7Q88epftG+NzNojMJY/ht4NlktNKj5yFupwRLckdxkAEfK2DivqHwX4G8PfDnw7a6D4X0Wx8P6NajEVjp0CwxL6nCgZJ7k8k8kmtyigAooooAKKKKACiiigAooooAKKKKACisLQ/HnhrxNrmr6NpHiDS9V1fR2RdSsbK8jmmsmfdsEyKSYydrYDAZ2n0rdoAKKKQkKCScAdzQAtFfLXxE/botE8VXvhT4N+CNT+OHiLSwZdX/sCZYrDT41yWVroqyPMQCFjTO45XO4ba9Z+A/7Q/gz9onws+seFL5/tFq/kalo18nk3+mTjIaG4hPKMCCM8qcHBOKAPFP24vhF8f/is+m2vw18RWcfgRIV/tjw1aag2lanqbb23ot5scLGybV25QctkNxjkfhD+0f8AD39k/wAOReGPF3wJ8T/AKyQqLjUhpx1TTZnHG6TUIAzzN/tMCcEc4r7lpskayxsjqHRgQysMgj0NAHE/Db44fD/4w2guPBXjLRfEy7dzR6depJLGP9uPO9PowFdxXgvxJ/YY+CPxPvP7Qv8AwLY6PrSt5keseHS2mXaSf398BUM3u4auHP7M3x1+FPz/AAr+Pl7rmnx/6vw/8TrQanGwHRTeoBMijphV6fSgD6yor5NP7Uvxp+FXyfFj4Aarf2Mf+s8Q/Da5XVoGHd/srETRqOpLHp24r2v4JftCeBP2hvD1xq3gjW01FbSTyL2ymjaC7speRsmhcBkPBwSMHBwTigD0eiqWs63p/hzSrrU9Wv7bTNNtYzLcXl5MsUMKDqzuxAUD1Jri/g/8fPAfx8sNZvvAXiCLxFZaRenT7q5gikSMTBQ2FLqA64YYZcqexNAHoNFFFAHn3xqs/iffeGLaP4U6j4Z0zXvtSm4m8UW880H2fa2QgiIIfds65GN3fFeKj4Z/tdal/wAfPxn8DaPn/oHeFjPj6ea3+cmvquigD5U/4Z3/AGmL75r39q42/pFY/D/T1AP+8XyfpSj4E/tSaWP9E/ae0/V1H3Y9T8A2UXHYFo3yeg568n2r6qooA+IfjNr37XHwB+F/iLxzc+NPAPjHT9Ctvtc9onh64juJIwwDMAjgYUHcxyMKGPYV81/tI/FD9rjx/wDCr4fX2s694X8OWPjuSC10nwl4Fu5Y9U1nzlDKzODJ+72MpbbMqAOAwyQK/Ub4s+L/AAv4D+GviTXfGs8EHhSzsZW1E3K7kkhK7THt/iL7tgXqxYAcmvzG/Yc8a+APgv4/1bXvjbqt/wCD7/RtJhb4e2Pi+Xf9j0G7kmlU24UEtKc7WOMhSVHGQADo/hLa/F//AIJmfA/XNT1f4S+E9U0oXK3Ws+IE8UrFd3bM4SKMKYyTt3bVRQeWY4yWr6R/Zd/bJ1zx9rGk+D/i/wCHLbwH428QWMet+HHtnJsNbsJUEiCByzfv41YB4y2TjIA5A8015bP/AIKa/FC9s9KuZ5vgL4KtZRFetFLBHruuTQsqMFcK3l26vnkA7vVZBjpv2c/hdoH7W37A3w90DxYk9lrOgwvp1pqlo3l32jXtlM8EUsLjlXVYozjoQcH2APoj46ftH+A/2dtCi1Dxhq4huro7LDR7NPP1DUJM4CQQD5nJJAzwoJGSM14GPhz8Zf2zj9o+JE178G/hHNzH4I0ufbrWrxdvt84/1KMOsK84JDAEBq9P+Bn7HnhX4Ra9L4w1rUL/AOI3xMuh/pPjLxK3nXQ4xst1JKwIBwAvODjcRgD3ugDmfh18NPC3wk8KWnhvwdoVl4e0S1H7uzso9qk92Y9Xc45ZiWPcmvHPjz+yYvjPxTH8SfhnrZ+HPxgs0xFrlqn+i6ogx/o9/CBiWM4A3EFhhfvBQtfRNFAHyDoH/BQCHwTHN4Z+MvgPxL4U+JOnkR3GnaJpM2o2moL2ubSWMEGNsdGOQeMtgmtQ/t5T6xx4Y/Z/+Mmu5+7cS+GRaWzfSSST+lfVVFAHyof2k/2iNe48P/ssX0ETdLnX/GFlZ7frFtLfkaa3iP8AbO8QZ+w+EPhH4TRv+gzqd9eOo/7YAAn9K+raKAPBf2Y/2lp/i82teDvGulR+EPi94Xbyde8OZIRl423dqSSXt3BUg5O3cASQVZvjz/go18WfBfwL+M+n+IPhtFrnh34924hmvdS0i02abeWj4Jjv1YbbglQMFVJ4AZsqoH17+1D+zbefFCTSPHngHUE8L/GPwrmXQ9bHEdynJayuh/HBICw5ztLHsWDa/wCzH+0lZ/H7w3f22oadJ4X+IPh6UWPibwtdcTafcjI3KDy0T4JR+QRxnINAH5t/Dn9qP4WfHvUj4i/ar8aeJNV1K2vC2m+AbTS54fD8KD7kojg3NOfeUg9QQ45r1D9jr9uH4H/BofGBdQvbrRrPXPHuo6lo9pp2hXBiTTSsSW2Fjj2x8Kw8vAK4HFfdX7QH7N3g39o3wzDpviW2lttTsX8/Sdf05/J1DS5wQRLBKORyASpypwMjIBHwz+wV+06n7P3hG70T4oWV5ZeDvEnijUptM+Jc/wA1ndXvm+XLHeEE+Q7NEWDE4IJzgKWoA99b/gqx+zkjFW8V6mrA4IOhXmQf+/dFfit8RtX8T/Ej4heJ/FqWmpFNe1S61UFVfGJ5Wl4xx/HRQB/TLRRRQAVn+IbK+1LQNTtNL1E6PqdxayxWuoiBZ/ssrIQkvlt8r7WIbaeDjB61oUUAfAfjb9hP9oP446pFo/xT/aGtta8E2U6ahapYaBBDNLdIfk823VEj2gFjhnkGf4e9djr3/BPXXfG2p2mpeK/j14t1zUbRDHBdtpliksKE5KxuY2KA+gPXmvsuigD5Nf8AYQ123ss2P7SnxjtdRhANo511GtI3H3d9uI1EieqbgD612H7F/wAAvGP7O3gXxXoHjLxFp3ie61LxLd61bX2nQtCDHOsZbfGVCxsZFdtiZUbuCeg+gqKACiiigAooooAKKKKACiiigAr5s/ab/Z517VPEdh8YvhHNDpHxh8Pw7PKkO228RWQwXsLoZAOQPkc4wcDIwrJ9J0UAeTfs+/tHeHv2gPh5P4hsYptI1XS3e017w/fDbd6Rdx58yGVTg8EHa2BkDsQwHjP/AAT08C6N49/YD8I6T4q0m11rTNeOpzX1jexCSKUPqFwRkHvgKQeoIBByAa8z/wCCily/7NPxC8GfFrwCf7H8T+LbmTw34hhUn7HqtqYvlaeIYzKnG2QEEYGc4r6E/wCCe1slr+xh8KUjGFOlFyPdppGP6k0Adxo/7Mfws0HSLLTLHwTpkVlZQJbQRsrOVjRQqgsxLNgAckknuTRXp9FAH//Z'

SELECT * FROM #test

How do i decrypt this data so i can print actual signature on my report.

any help much appreciated


May 20th, 2015 7:21pm

Hopefully not a real signature... or you've modified a few characters to prevent someone else determining someone's signature.

As for the question, is it not just an image file? Sounds like something better stored as varbinary than varchar but may just be a case of converting back to varchar.

If it is genuinely encrypted, then you would need the decryption algorithm to convert back, ask whoever created the encryption

Free Windows Admin Tool Kit Click here and download it now
May 20th, 2015 10:00pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics