Weird thing with DES

[soup_or_power]

I use the DES_ENCRYPT and DES_DECRYPT with the string 'sfG3853ncr1pt'
I can't seem to encrypt the number 227968199 because I tried several
times and also tried other numbers which work fine.

Here is a sample session:
mysqlcreate table `destest` (num varchar(17));
Query OK, 0 rows affected (0.04 sec)
mysqldesc destest;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| num | varchar(17) | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
1 row in set (0.00 sec)
mysqlinsert into destest(num) values(DES_ENCRYPT('227968199',
'sfG3853ncr1pt'));
Query OK, 1 row affected (0.00 sec)
mysqlselect * from destest;
+------------------+
| num |
+------------------+
| ÿÿÔ¨ð!?`f4~±ëk† |
+------------------+
1 row in set (0.00 sec)
mysqlselect DES_DECRYPT(num, 'sfG3853ncr1pt') from destest;
+-----------------------------------+
| DES_DECRYPT(num, 'sfG3853ncr1pt') |
+-----------------------------------+
| ÿÿÔ¨ð!?`f4~±ëk† |
+-----------------------------------+
1 row in set (0.00 sec)
mysqlinsert into destest(num) values(DES_ENCRYPT('12345678',
'sfG3853ncr1pt'));
Query OK, 1 row affected (0.00 sec)
mysqlselect DES_DECRYPT(num, 'sfG3853ncr1pt') from destest;
+-----------------------------------+
| DES_DECRYPT(num, 'sfG3853ncr1pt') |
+-----------------------------------+
| ÿÿÔ¨ð!?`f4~±ëk† |
| 12345678 |
+-----------------------------------+
2 rows in set (0.00 sec)
I have also tried

FLUSH DES_KEY_FILE;
It is so weird!
Reply »