1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

how to decode varchar 255?

Discussion in 'Databases' started by arale, Jun 6, 2009.

  1. #1
    Hi,
    SEMrush
    I have a string encrypted by varchar(255), I need to decode it. How to do that? :confused:

    arale
     
    arale, Jun 6, 2009 IP
    SEMrush
  2. Social.Network

    Social.Network Member

    Messages:
    517
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    35
    #2
    varchar(255) is not a form of encryption, it is a data type and length. Can you provide additional information?
     
    Social.Network, Jun 6, 2009 IP
  3. arale

    arale Guest

    Messages:
    1,215
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I have a field on SQL, its password for user which use varchar(255) and it look like this e10adc3949ba59abbe56e057f20f883e

    I want to convert it to plain text, is it possible?
     
    arale, Jun 6, 2009 IP
  4. Social.Network

    Social.Network Member

    Messages:
    517
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    35
    #4
    It depends on the form of encryption. Is this a custom, open-source, or commercial application? The string you posted could be a MD5 hash; do you know what type of encryption is used?
     
    Social.Network, Jun 6, 2009 IP
  5. arale

    arale Guest

    Messages:
    1,215
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    0
    #5
    arale, Jun 6, 2009 IP
  6. Social.Network

    Social.Network Member

    Messages:
    517
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    35
    #6
    I cannot tell from the screenshot, sorry.
     
    Social.Network, Jun 6, 2009 IP
  7. jestep

    jestep Prominent Member Premium Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #7
    You would need to look at the application and see how the password is inserted. Most likely it is a hash, and cannot be decrypted. Normally you would use char 32 (at least for MD5) but a varchar field would work fine, although not ideal. If it is a hash, there is no way to decode it. You can only update the value in that field.
     
    jestep, Jun 7, 2009 IP
  8. arale

    arale Guest

    Messages:
    1,215
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    0
    #8
    I found this encoded by MD5, I tried some tools but not success. Any chance for me now? :(
     
    arale, Jun 8, 2009 IP
  9. veracious

    veracious Banned

    Messages:
    311
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #9
    You can always update the password if you have the privs, without trying to decrypt this one.
     
    veracious, Jun 9, 2009 IP
  10. sssharlasss

    sssharlasss Peon

    Messages:
    17
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #10
    The idea with password hashes is that they're one way only, which essentially means that you can't decrypt it. Now, you might be able to find a collision, but that is probably more technically involved than you'd like. And even then, you probably wouldn't get the password, but instead only a string that has the same hash.

    The best idea for you, depending on what you're trying to do, is to create an MD5 hash of a password you want to use, and replace THAT value with the new hash. Here's a site that'll work for you:

    http://www.xs4all.nl/~jlpoutre/BoT/Javascript/Utils/md5_hashing.html

    Something to also consider is the possible use of a salt, which would just throw an extra wrench in your cogs.
     
    sssharlasss, Jun 9, 2009 IP