Re: describe table from oracle to mysql shows wrong data type
Hi BOgdan
Ok, let me get the trace later today. I also tested8.0.32 with same output.
I tried 8.0.28 and got something different
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 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.28
SQL> desc "lecturas"@mysql_t
Name Null? Type
----------------------------------------- -------- ----------------------------
idSim NOT NULL NUMBER(10)
idAlfresco NOT NULL VARCHAR2(195)
nombre NOT NULL VARCHAR2(180)
descripcion VARCHAR2(1500)
bloqueado CHAR(3)
So the output is different but I deduced that it is showing CHARACTER_OCTET_LENGTH instead of CHARACTER_MAXIMUM_LENGTH in information_schema.columns. Not sure why this is happening and the impact?
Thanks
Subject
Written By
Posted
February 07, 2023 07:56AM
February 07, 2023 09:27PM
Re: describe table from oracle to mysql shows wrong data type
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.