Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › 求助：ORACLE DBlink mysql 显示不完整的问题 ...

zxjlqh

0 积分	1 好友	9 主题

发消息

[SQL调优] 求助：ORACLE DBlink mysql 显示不完整的问题

1^#

发表于 2013-3-25 15:27:17 | 查看: 4021| 回复: 3

环境11G Redhat 5.8 64
   mysql 5.1 redhat 5.8 32

请大神指点，mysql中CHAR字段的手机号只显示前6个数字，怎么解决啊！

odbc.ini
[test]
Driver =/usr/lib64/libmyodbc5.so
Description = MySQL ODBC3.51Driver DSN
SERVER =192.168.200.171
PORT =3306
UID =mysqldba
Password =123456
Database =hsh
OPTION =3
SOCKET =
charset =gbk
STMT =SET NAMES 'GBK'

cat /u01/app/oracle/product/11.2.0/db_1/hs/admin/inittest.ora
HS_FDS_CONNECT_INFO = test
HS_FDS_TRACE_LEVEL = off
HS_FDS_SHAREABLE_NAME =/usr/lib64/libodbc.so

#
# ODBC specific environment variables
#
set ODBCINI=/etc/odbc.ini

.bash_profile

export PATH
# User specific environment and startup programs
export ORACLE_SID=dblink
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin
#export SQL_PATH='/home/oracle'
#export LD_LIBRARY_PATH=/lib
#alias  sqlplus='rlwrap sqlplus'
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
#alias  rman='rlwrap rman'
#alias  dgmgrl='rlwrap dgmgrl'
#alias  tailoraalert="/admin//bdump/alert_.log"
export LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib:/usr/lib
ODBCINI=/etc/odbc.ini; export ODBCINI
ODBCSYSINI=/etc; export ODBCSYSINI

查询结果，手机号只有前6位。如果Driver =/usr/lib64/libmyodbc5.so换成libmyodbc3.so，手机号可显示完整，但是8条记录，只显示4条。CPhone是char字段，我在mysql中改成varchar也一样的结果。

SQL> select "CPhone","CCreated" from "TCustomer"@mysql;

CPhone                CCreated
---------------------- --------------
1 8 0 3 3 4          04-3月 -13
1 3 5 1 0 4          02-3月 -13
1 8 0 3 8 0          02-3月 -13
1 5 9 1 4 1          04-3月 -13
1 3 7 2 5 5          05-3月 -13
1 8 0 2 8 7          06-3月 -13
1 5 8 1 7 3          06-3月 -13
1 5 9 1 4 1          06-3月 -13

分享0