[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 405
  • Last Modified:

How to decode a column with encoded data in MS SQL

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
0
newone2011
Asked:
newone2011
  • 2
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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.
0
 
tigin44Commented:
how did the column encoded? which algorithm used? do the keys available for encoding operation?
0
 
newone2011Author Commented:
Its not encrypted.
I believe it is standard url encoding.
For example, I am able to decode the text using
http://meyerweb.com/eric/tools/dencoder/

0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you might check out this one, then:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=88926
0
 
newone2011Author Commented:
Partial
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now