MySQL Forums
Forum List  »  Connector/ODBC

Advanced Search
New Topic

Bigint corruption with MySQL ODBC connector for windows 10
Posted by: Jeremy LAGER
Date: February 07, 2024 10:39AM

Hi,

I'm trying to pull a BIGINT column with SSIS an package and MySQL ODBC Connector 8.00.36.00 to insert into SQL Server 2019, and the column becomes corrupted

On a closer look, when you examine the binary words involved, it seems as though the endianness of the column gets reversed coming through the driver... e.g.:

src BIGINT(MySQL8) 43185
dstn DT_UI8(SSIS) 228576015156
ltl-endian binary 0x3433313835000000
big-endian binary 0x0000003538313334

is there any explanation / solution?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Bigint corruption with MySQL ODBC connector for windows 10
Jeremy LAGER
February 07, 2024 10:39AM
Re: Bigint corruption with MySQL ODBC connector for windows 10
Bogdan Degtyariov
February 08, 2024 09:47PM
Re: Bigint corruption with MySQL ODBC connector for windows 10
Jeremy LAGER
February 09, 2024 03:47AM


Sorry, only registered users may post in this forum.
Click here to login

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.