How to decode a column with encoded data in MS SQL

Posted on 2011-10-20
Last Modified: 2012-06-21
I have a column which has encoded data. Can I decode this in MS SQL using any function ? I want to see if I can do without using java
Question by:newone2011
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    you need to know how the data is actually encoded.
    if it's encrypted, you need to know the encryption function and usually also the encryption keys/seeds/certificates etc.

    if it's a hashed value, you cannot "decode" it.
    LVL 26

    Expert Comment

    how did the column encoded? which algorithm used? do the keys available for encoding operation?

    Author Comment

    Its not encrypted.
    I believe it is standard url encoding.
    For example, I am able to decode the text using

    LVL 142

    Accepted Solution

    you might check out this one, then:

    Author Closing Comment


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now