Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    New to the CF scene
    Join Date
    Aug 2012
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    what kind of code encryption / compression is this?

    Hello,
    yesterday in my office i found these strings in sql lite database, which I know exist in our application, they are coded description of civil engineering work activities

    SQB6AHIAYQBkAGEAIABuAGEAZABzAHQAcgBlAGEBbgBpAGMAZQA=
    i know that string above is coded string:
    Izrada nadstrešnice
    which is "making of rain protection roof" in english

    SQB6AHIAYQBkAGEAIABhAHIAbQBpAHIAYQANAWsAbwBnACAAcwB0AG8AbABhAA==
    this is coded string:
    Izrada armiračkog stola
    which is "making of armature table" in english

    I have whole database full of these encoded strings running at my local server.

    I was wondering, is there a way to found out what kind of encryption / compression method was used to store this text string into database?

  • #2
    Regular Coder Arcticwarrio's Avatar
    Join Date
    May 2012
    Location
    UK
    Posts
    709
    Thanks
    20
    Thanked 84 Times in 84 Posts
    how were they entered into the database?
    There are 10 types of people on CodingForums,
    Those who understand Binary and those who dont.
    Get Cloud Hosting now from only£59 / month

  • #3
    New to the CF scene
    Join Date
    Aug 2012
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    There is a desktop application with file I opened and saw sqlite schema. So I imported it into our web server and there they show up in a table. There is about 20,000 of these entries. And there is a md5_and_reverse() function which shows up in swlitemanager on server when I open this db, but I can not figure out is it md5 or something else.

  • #4
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,979
    Thanks
    4
    Thanked 2,659 Times in 2,628 Posts
    Its not a compression or encryption at all.
    That's simply base64 encoded (which is faaaarrrrr from compression for sure). I'm not sure what you're talking about for an md5 reversal, that's a hashing method, so it cannot be reversed. It can be easily brute forced though which is why md5 is not recommended.

    I would presume this was done as it is likely using a latin charset.

  • #5
    New to the CF scene
    Join Date
    Aug 2012
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I guess "š đ ž ć č" are latin charset.

    Thank you for the extensive info! I understood it all.

  • #6
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,979
    Thanks
    4
    Thanked 2,659 Times in 2,628 Posts
    None of those characters is in the latin charset. What I mean is I would presume the reason for the base64 is since the database is stored in a latin charset, so it cannot properly store those characters. It can be changed from a latin charset to a unicode one which should be able to store those characters.


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •