describe table from oracle to mysql shows wrong data type
Hi
I have upgraded mysql odbc in a server where Oracle 19c is running, we use this ODBC to access a remote MYSQL database. The ODBC driver installed is 8.0.31.
The developers noticed that when describe table we see different behaviour compare with previous ODBC which was 5.3.6.
ODBC 5.3.6
SQL> desc "lecturas"@mysql_t
Name Null? Type
----------------------------------------- -------- ----------------------------
idSim NOT NULL NUMBER(10)
idAlfresco NOT NULL VARCHAR2(65 CHAR)
nombre NOT NULL VARCHAR2(60 CHAR)
descripcion VARCHAR2(500 CHAR)
bloqueado CHAR(1 CHAR)
ODBC 8.0.31
SQL> desc "lecturas"@mysql_t
Name Null? Type
----------------------------------------- -------- ----------------------------
idSim NOT NULL NUMBER(10)
idAlfresco NOT NULL VARCHAR2(780)
nombre NOT NULL VARCHAR2(720)
descripcion LONG
bloqueado CHAR(12)
Anyone have observer this behaviour change?
Subject
Written By
Posted
describe table from oracle to mysql shows wrong data type
February 07, 2023 07:56AM
February 07, 2023 09:27PM
February 08, 2023 01:01AM
February 08, 2023 01:38AM
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.