MySQL Forums
Forum List  »  Oracle

Strange scenario,Oracle can not display the data in mysql correctly
Posted by: wang xi
Date: October 09, 2010 01:34AM

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.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.