MySQL Forums
Forum List  »  Connector/ODBC

describe table from oracle to mysql shows wrong data type
Posted by: General Info
Date: February 07, 2023 07:56AM

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?

Options: ReplyQuote


Subject
Written By
Posted
describe table from oracle to mysql shows wrong data type
February 07, 2023 07:56AM


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.