-
BIGINT conversion problem
I have created database link (hsodbc) in my Oracle9i
DB to MYSQL database using MySQL ODBC 3.51 Driver.
In MySQL database i have some table with BIGINT data type columns.
When I try to fetch BIGINT columns values in MYSQL from oracle DB through DBLINK i get
not properly converted values.
For example:
Query executed in ORACLE9i:
select "Column1" from table1@MYSQL_DB where "Id"=153;
gives next result: 13564894837420337.
The same query executed in MYSQL db:
select Column1 from table1 where Id=153;
gives result: 1132310431406
Is there any idea???
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|