LDD

[root@fddc ~]# ldd /u01/app/product/11.2.0/dbhome_1/lib/libsqora.so.11.1
        linux-vdso.so.1 =>  (0x00007ffffa3ff000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007feea843a000)
        libm.so.6 => /lib64/libm.so.6 (0x00007feea81b5000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007feea7f98000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00007feea7d7f000)
        libclntsh.so.11.1 => /u01/app/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1 (0x00007feea53f2000)
        libodbcinst.so.1 => /usr/lib64/libodbcinst.so.1 (0x00007feea51e1000)
        libc.so.6 => /lib64/libc.so.6 (0x00007feea4e4e000)
        /lib64/ld-linux-x86-64.so.2 (0x0000003d9bc00000)
        libnnz11.so => /u01/app/product/11.2.0/dbhome_1/lib/libnnz11.so (0x00007feea4a81000)
        libaio.so.1 => /lib64/libaio.so.1 (0x00007feea4880000)
        libltdl.so.7 => /usr/lib64/libltdl.so.7 (0x00007feea4677000)
[root@fddc ~]# 
[root@fddc ~]# 
[root@fddc ~]# ldd /usr/local/mysql/lib/plugin/ha_connect.so
        linux-vdso.so.1 =>  (0x00007fff59be4000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fd89d68e000)
        libz.so.1 => /lib64/libz.so.1 (0x00007fd89d477000)
        libxml2.so.2 => /usr/lib64/libxml2.so.2 (0x00007fd89d125000)
        libodbc.so.2 => /usr/local/unixODBC/lib/libodbc.so.2 (0x00007fd89ceb9000)
        libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007fd89cbb2000)
        libm.so.6 => /lib64/libm.so.6 (0x00007fd89c92e000)
        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007fd89c718000)
        libc.so.6 => /lib64/libc.so.6 (0x00007fd89c384000)
        /lib64/ld-linux-x86-64.so.2 (0x0000003d9bc00000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007fd89c180000)

[root@fddc ~]# 

export PATH
export PATH=/usr/local/unixODBC/bin:/usr/local/mysql/bin:$PATH
export ORACLE_HOME=/u01/app/product/11.2.0/dbhome_1
export ODBCHOME=/usr/local/unixODBC
export LD_LIBRARY_PATH=/usr/local/unixODBC/lib:$ORACLE_HOME/lib
##export NLS_LANG="SIMPLIFIED CHINESE_CHINA".ZHS16GBK
#export NLS_LANG="Simplified Chinese_china".ZHS16GBK 
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export LANG=en_US


FREETDS_HOME=/usr/local/freetds
export PATH=$FREETDS_HOME/bin:$PATH


alias mysqllog='tail -100f /data/mysql/data/fddc.err'
[root@fddc ~]# 
[root@fddc ~]# 
[root@fddc ~]# which isql
/usr/local/unixODBC/bin/isql
[root@fddc ~]# 
[root@fddc ~]# rpm -qa |grep unixODBC
unixODBC-devel-2.2.14-12.el6_3.x86_64
unixODBC-2.2.14-12.el6_3.x86_64
[root@fddc ~]# 

MariaDB [(none)]> show variables like '%char%';
+--------------------------+----------------------------------+
| Variable_name            | Value                            |
+--------------------------+----------------------------------+
| character_set_client     | utf8                             |
| character_set_connection | utf8                             |
| character_set_database   | utf8                             |
| character_set_filesystem | binary                           |
| character_set_results    | utf8                             |
| character_set_server     | utf8                             |
| character_set_system     | utf8                             |
| character_sets_dir       | /usr/local/mysql/share/charsets/ |
+--------------------------+----------------------------------+
8 rows in set (0.00 sec)


MariaDB [(none)]> 

MariaDB [(none)]> show variables like 'collation_%';
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    32675
Current database: *** NONE ***


+----------------------+-----------------+
| Variable_name        | Value           |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database   | utf8_general_ci |
| collation_server     | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.00 sec)

MariaDB [(none)]> select * from information_schema.schemata;
+--------------+--------------------+----------------------------+------------------------+----------+
| CATALOG_NAME | SCHEMA_NAME        | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | SQL_PATH |
+--------------+--------------------+----------------------------+------------------------+----------+
| def          | checkdb            | gbk                        | gbk_chinese_ci         | NULL     |
| def          | information_schema | utf8                       | utf8_general_ci        | NULL     |
| def          | mysql              | utf8                       | utf8_general_ci        | NULL     |
| def          | performance_schema | utf8                       | utf8_general_ci        | NULL     |
| def          | test               | utf8                       | utf8_general_ci        | NULL     |
+--------------+--------------------+----------------------------+------------------------+----------+
5 rows in set (0.01 sec)