ODBC to Dynamics - Long text truncate

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
babylonlin
Posts: 2
Joined: Fri 26 Oct 2018 06:46

ODBC to Dynamics - Long text truncate

Post by babylonlin » Fri 26 Oct 2018 06:54

Hi guys,

I encounter one problem when I use DBeaver and ODBC for Dynamics to connect to our dynamics 365. I would like to retrieve the email body from activitypointer table. Since the mail body is very long text, the results are always truncated. How should I get the full long text results? I tried both 64 and 32 bit odbc. Both results are same.

Thanks a lot in advance

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

Re: ODBC to Dynamics - Long text truncate

Post by MaximG » Fri 26 Oct 2018 11:32

Please describe the issue in more detail. What is the exact SQL query used for retrieving the required data. What is the full content of the field, the value of which eventually is cut off

babylonlin
Posts: 2
Joined: Fri 26 Oct 2018 06:46

Re: ODBC to Dynamics - Long text truncate

Post by babylonlin » Fri 26 Oct 2018 14:33

Email body is saved in Table activitypointer in the columns - "description". This column is longtext and stores the email body in HTML format, which contains normally 10000+characters. If I run sql script select description from activitypointer. Only the first 2000 characters are shown as results, so to say the content is truncated.

I use dbeaver 5,2,3 for database client. And ODBC is the most updated version.

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

Re: ODBC to Dynamics - Long text truncate

Post by MaximG » Wed 31 Oct 2018 10:50

We investigated the operation of our driver according to your description. Indeed, the "description" field of the "activitypointer" table will be represented in our driver by the type SQL_VARCHAR of 2000 characters long. This value is returned by DynamicsCRM API in the process of receiving the metadata of the "activitypointer" table and we cannot influence this behavior.

Post Reply