Advertisement

06.02.2005 at 01:04PM PDT, ID: 21445110
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!
7.6

How to secure a long text stored in MySQL?

Asked by skinnyp in MySQL Server

Tags: , ,

Hello,
I have a long text (lowercase char and int, no space) need to be stored in the mysql database: ie:

text:
5cd079ba15e82976bf42f4fddec2cc76
d5aba97900c109e1f83edbe8c1e90489
19d049570aef8fa1574803b85b04c975
b2904ac06e16c2157b31e381f6be5e43
e8596cc521235de4b4159b243a69
cc3add3c17a9a7d79f496dd38c9a0bd1
cdd3dd2220c760a3d7c13a364d1033c9
c08a86ba54c074dd18c457030847c9ae
92f9fdd90ce22a46989238321e58ecf3
ea9f59505ce1661788ccdd11bd5b45d5
e7c7c82df33f4da997bda001e40a1903
77de8ccbc9618e5d86873cc6baeb8016
480aca28fb28f5694514bde4a9f82ccd
758262dfd3a9c83a920c695c3e7549ce
cc3add3c17a9a7d79f496dd38c9a0bd1
cdd3dd2220c760a3d7c13a364d1033c9
c08a86ba54c074dd18c457030847c9ae
92f9fdd90ce22a46989238321e58ecf3
ea9f59505ce1661788ccdd11bd5b45d5
e7c7c82df33f4da997bda001e40a1903
77de8ccbc9618e5d86873cc6baeb8016
480aca28fb28f5694514bde4a9f82ccd
758262dfd3a9c83a920c695c3e7549ce
224881c5b4b13sdds63fc8ca3bdd39c6
224881c5b4b13sdds63fc8ca3bdd39c6
72f39aa96d281d9d5dab78fc3fef05b8
4b9abf7ea7b6asd39e246509cc456c9
d6c840b0624b7d5313234e12e64ccade
281649e44875ba2e7efef25036ed93a3
d1b86c8237e039604807159022e88024
019a2e4062d45b822b1435d67a14ec02
f48c526fb764e4c2206715295151de0a
9506a369f280b89430200580f0708e29

 I want to secure the text by using the MySQL encode function:

Encode($longtext, $mykey), however I am not able to retrieve the text using:
Decode($longtext, $mykey), and when I do this, I only retrieve some weird characters.

My Questions are:
1. Why I retrieve some weird text when using Decode()?
2. Besides Encode, what other function can be used to BOTH Encrypt and Decrypt the text?

Thank you
Start Free Trial
[+][-]06.02.2005 at 02:20PM PDT, ID: 14134836

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.02.2005 at 04:20PM PDT, ID: 14135762

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.03.2005 at 07:40AM PDT, ID: 14140075

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.09.2005 at 08:00AM PDT, ID: 14180444

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MySQL Server
Tags: mysql, longtext, encode
Sign Up Now!
Solution Provided By: brakk0
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32