查询输出乱码
IBM TSM server 的 DB2 数据库 DB2/AIX64 9.7.6. 有一个表 "occupany"
aix1:/tmp/zy $ db2 "describe table occupancy"
Data type Column
Column name schema Data type name Length Scale Nulls
------------------------------- --------- ------------------- ---------- ----- ------
NODE_NAME SYSIBM VARCHAR 65 0 Yes
TYPE SYSIBM VARCHAR 4 0 Yes
FILESPACE_NAME SYSIBM VARCHAR 1025 0 Yes
STGPOOL_NAME SYSIBM VARCHAR 31 0 Yes
NUM_FILES SYSIBM INTEGER 4 0 No
PHYSICAL_MB SYSIBM DECIMAL 14 2 No
LOGICAL_MB SYSIBM DECIMAL 14 2 Yes
REPORTING_MB SYSIBM DECIMAL 14 2 Yes
FILESPACE_ID SYSIBM INTEGER 4 0 Yes
9 record(s) selected.
以下查询很明显 filespace_name 匹配了 '/var/mqm'. 请问为什么输出乱码 x'2F7661722F6D716D' 请指教。谢谢
aix1:/tmp/zy $ db2 "select filespace_name from occupancy where node_name='AIX2' and filespace_name='/var/mqm'"
FILESPACE_NAME --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
x'2F7661722F6D716D'
1 record(s) selected.
aix1:/tmp/zy $
aix1:/tmp/zy $ db2 "describe table occupancy"
Data type Column
Column name schema Data type name Length Scale Nulls
------------------------------- --------- ------------------- ---------- ----- ------
NODE_NAME SYSIBM VARCHAR 65 0 Yes
TYPE SYSIBM VARCHAR 4 0 Yes
FILESPACE_NAME SYSIBM VARCHAR 1025 0 Yes
STGPOOL_NAME SYSIBM VARCHAR 31 0 Yes
NUM_FILES SYSIBM INTEGER 4 0 No
PHYSICAL_MB SYSIBM DECIMAL 14 2 No
LOGICAL_MB SYSIBM DECIMAL 14 2 Yes
REPORTING_MB SYSIBM DECIMAL 14 2 Yes
FILESPACE_ID SYSIBM INTEGER 4 0 Yes
9 record(s) selected.
以下查询很明显 filespace_name 匹配了 '/var/mqm'. 请问为什么输出乱码 x'2F7661722F6D716D' 请指教。谢谢
aix1:/tmp/zy $ db2 "select filespace_name from occupancy where node_name='AIX2' and filespace_name='/var/mqm'"
FILESPACE_NAME --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
x'2F7661722F6D716D'
1 record(s) selected.
aix1:/tmp/zy $