Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Incomplete
-
5.5.40
-
None
Description
I was working trying to remove some corrupt data from a table and noticed that the field was being displayed differently depending on whether or not I used the \G modifier on the query...
|
|
mysql> select pid from players where id=29354221;
|
+------------+
|
| pid |
|
+------------+
|
| s p c i a |
|
+------------+
|
1 row in set (0.00 sec)
|
|
|
mysql> select pid from players where id=29354221\G
|
*************************** 1. row ***************************
|
pid:
|
1 row in set (0.00 sec)
|
|
|
mysql> select hex(pid) from players where id=29354221\G
|
*************************** 1. row ***************************
|
hex(pid): 00730070006300690061
|
1 row in set (0.01 sec)
|
|
|