Strange scenario,Oracle can not display the data in mysql correctly

[wang xi]

I use Heterogeneous Service+ODBC method to achieve "oracle access mysql"(any other method?),and now i find Oracle can not display the data in mysql correctly:

-------mysql------------
mysql> create table tst(id int,name varchar(10));
Query OK, 0 rows affected (0.00 sec)

mysql> insert into tst values(1,'a');
Query OK, 1 row affected (0.00 sec)


mysql> select * from tst;
+------+------+
| id | name |
+------+------+
| 1 | a |
+------+------+
1 row in set (0.00 sec)

mysql> show create table tst\G
*************************** 1. row ***************************
Table: tst
Create Table: CREATE TABLE `tst` (
`id` int(11) DEFAULT NULL,
`name` varchar(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8
1 row in set (0.00 sec)

-------------oracle ------------------

SQL> select count(*) from "tst"@mysql;

COUNT(*)
----------
49

SQL> select * from "tst"@mysql;

id
----------
1

SQL> desc "tst"@mysql;
Name Null? Type
----------------------------------------- -------- ----------------------------
id NUMBER(10)



Edited 1 time(s). Last edit at 10/09/2010 01:34AM by wang xi.