I manage our mySQL database through putty (SSH terminal client).
And whenever I do a select * from the table that contains ENCODEd
passwords, the funky characters do funky things with the display.
From doing weird alignment things, to making it so that so long as
those characters are visible, the display is always scrolled to a line
where one of those screwy ASCII characters are. I can scroll up or
down, but as soon as I type something on the command line, the display
scrolls back so that particular odd character is on display line one.
Weird behavior like that.
Is there something I'm doing wrong with the table type? Something I
should set the putty terminal to (like a certain display type...I
don't know.)
Below is one of the tables that use ENCODE passwords and a sample
display.
Thanks for any suggestions!
mysql> select * from tbl_users;
+----+----------+----------+-------------+----------+--------+----------------------------------------+
| id | username | password | fullname | created | active | email
|
+----+----------+----------+-------------+----------+--------+----------------------------------------+
| 1 | liam | ËæËØ | LRW | 20040406 | 1 |
liam@clipped |
| 2 | chipper | ÛÐ-]¿í=j | Super Duane | 20040407 | 0 |
|
| 3 | mccarter | ýàõJ¾]" | Angela | 20040412 | 1 |
customerservice@clipped |
×e 4 | sarah | 0
LÒ | Sarah | 20040412 | 1 | sarah@clipped |
| 5 | duane | ªéüXòTÜ | Duane | 20040412 | 1 |
designer@clipped |
| 6 | Jerry1 | áÖJì | Jerry | 20040422 | 1 |
jerry@clipped |
| 7 | bryan | ÛÐ-]ÍJ | Bryan K | 20040512 | 1 |
|
| 8 | david | ÛÐ-éÍJ | David V | 20040512 | 1 |
|
}¼=j | Ken K | 20040512 | 0 |
|
+----+----------+----------+-------------+----------+--------+----------------------------------------+
9 rows in set (0.00 sec)
mysql> explain tbl_users;
+----------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| username | text | | | | |
| password | blob | | | | |
| fullname | text | YES | | NULL | |
| created | varchar(8) | | | | |
| active | char(1) | | | 1 | |
| email | text | | | | |
+----------+------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)