MySQL Forums
Forum List  »  Connector/ODBC

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

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

Options: ReplyQuote


Subject
Written By
Posted
Re: describe table from oracle to mysql shows wrong data type
February 08, 2023 01:01AM


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.