I'm sorry, I don't know if this is a mySQL issue, or a Putty error, or
what. So if there's a better newsgroup for this question, please let
me know.
I'm using Putty to SSH into our remote Linux server. On one of our
mySQL databases, we have a table of users. One of the fields used to
store passwords we have as type "BLOG" and we use the ENCODE/DECODE to
encrypt passwords.
Now, when we do a select of a row from that table, because the
password field is encrypted and displays funky ASCII characters
instead of a password, I think some of those characters are being
interpreted by Putty as formatting characters because it will do some
weird things with the display.
Like this:
mysql> select * from tbl_users;
+----+----------+----------+-------------+----------+--------+----------------------------------------+-------+
| id | username | password | fullname | created | active | email
| admin |
+----+----------+----------+-------------+----------+--------+----------------------------------------+-------+
| 1 | liam | ËæËØ | LRW | 20040406 | 1 |
li**@SNIP.com | 1 |
| 2 | chipper | ÛÐ-]¿í=j | Super Duane | 20040407 | 0 |
| 0 |
| 3 | mccarter | ýàõJ¾]" | Angela | 20040412 | 1 |
cu*************@SNIP.com | 0 |
×e 4 | sarah | 0
LÒ | Sarah | 20040412 | 1 | sa***@SNIP.com | 0
|
| 5 | duane | ªéüXòTÜ | Duane | 20040412 | 1 |
de******@SNIP.com | 0 |
| 6 | Jerry1 | áÖJì | Jerry | 20040422 | 1 |
je***@SNIP.com | 0 |
| 7 | bryan | ÛÐ-]ÍJ | Bryan K | 20040512 | 1 |
| 1 |
| 8 | david | ÛÐ-éÍJ | David V | 20040512 | 1 |
| 0 |
}¼=j | Ken K | 20040512 | 1 |
| 1 |
+----+----------+----------+-------------+----------+--------+----------------------------------------+-------+
9 rows in set (0.00 sec)
I looked through Putty settings, and can't find anything that seems to
have anything to do with this issue.
So, any suggestions?
Thanks!
Liam