what kind of code encryption / compression is this?

[trileletri]

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?

[Arcticwarrio]

how were they entered into the database?

[trileletri]

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.

[Fou-Lu]

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.

[trileletri]

I guess "š đ ž ć č" are latin charset.

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

[Fou-Lu]

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.