Int64 support

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
Dmalx
Posts: 1
Joined: Thu 30 Jan 2020 23:13

Int64 support

Post by Dmalx » Thu 30 Jan 2020 23:44

I am using ODBC driver to connect SQLite to Power BI (or excel). The issue is Int64 value is truncated to 32 bits. F.x.:
6269010728497363496 = 0x5700000AFD32BA28
-8358680861215162072 = 0x8C00000AFC6A0128

are presented as
-47007192 = 0xFFFFFFFFFD32BA28
-60161752 = 0xFFFFFFFFFC6A0128

The data type set to whole number in P BI that is Int64

How to fix the problem?

MaximG
Devart Team
Posts: 1477
Joined: Mon 06 Jul 2015 11:34

Re: Int64 support

Post by MaximG » Mon 03 Feb 2020 09:46

What exact version of the driver do you have? Please send the DDL script that creates a table where the Int64 values are stored.

Post Reply