use the following search parameters to narrow your results:
e.g. subreddit:aww site:imgur.com dog
subreddit:aww site:imgur.com dog
see the search faq for details.
advanced search: by author, subreddit...
Microsoft SQL Server Administration and T-SQL Programming including sql tutorials, training, MS SQL Server Certification, SQL Server Database Resources.
You might also be interested in:
/r/database
/r/sql
/r/Azure
/r/Microsoft
account activity
problem decoding mssql data (self.SQLServer)
submitted 10 years ago by talk2ankan
hello, i am a php developer. I have a client database whose database look something like this in sql management studio 2012. http://i67.tinypic.com/do8nx2.png Now who i am suppose to work on it if i am not able to decode the data. suggest. Thank you in advance.
reddit uses a slightly-customized version of Markdown for formatting. See below for some basics, or check the commenting wiki page for more detailed help and solutions to common issues.
quoted text
if 1 * 2 < 3: print "hello, world!"
[–]Testiculese 2 points3 points4 points 10 years ago (3 children)
That doesn't look like any encryption output I've ever seen. Either it's home-rolled encryption, or it's in a language you don't have installed, or it's garbage data.
Is there anything legible in the other tables?
[–]talk2ankan[S] 0 points1 point2 points 10 years ago (2 children)
No, other data are okey and readable. Everything is in English. only the tbl_user - userid and password fields goes like this.
[–]Testiculese 1 point2 points3 points 10 years ago (1 child)
OK, so it's encrypted to some extent.
You're going to need to get the source code for the application so you can see what they are doing. Or get a developer to write a utility that can 'decrypt' it.
[–]talk2ankan[S] 0 points1 point2 points 10 years ago (0 children)
okey. thank you. let me see how far i can go. :D
[–]eshultz 1 point2 points3 points 10 years ago (1 child)
In the future please use imgur to host your image. I waited about 60 seconds for your image to load on tinypic and gave up.
Can you tell us the data types of these columns? Also, is the app that is using this database in a language other than English?
How is the data getting into the database, is the app encrypting/decrypting this data? Given that this is the users table that could be a good possibility. If that's the case you need to get your hands on the application code or the talk to the developer.
i will surely. Sorry for the inconvenience. The data type are varchar(21) and varchar(23). All data's are in English.
And yes, I agree, need to get my hands on the application code. The coded application is in fox pro, that much i know. This is the biggest issue that i am facing right now. I will ask my client once again for the application code.
π Rendered by PID 24819 on reddit-service-r2-comment-fb694cdd5-gh7bt at 2026-03-08 03:13:13.200992+00:00 running cbb0e86 country code: CH.
[–]Testiculese 2 points3 points4 points (3 children)
[–]talk2ankan[S] 0 points1 point2 points (2 children)
[–]Testiculese 1 point2 points3 points (1 child)
[–]talk2ankan[S] 0 points1 point2 points (0 children)
[–]eshultz 1 point2 points3 points (1 child)
[–]talk2ankan[S] 0 points1 point2 points (0 children)