Page 1 of 1

ODBC to Dynamics - Long text truncate

Posted: Fri 26 Oct 2018 06:54
by babylonlin
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

Re: ODBC to Dynamics - Long text truncate

Posted: Fri 26 Oct 2018 11:32
by MaximG
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

Re: ODBC to Dynamics - Long text truncate

Posted: Fri 26 Oct 2018 14:33
by babylonlin
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.

Re: ODBC to Dynamics - Long text truncate

Posted: Wed 31 Oct 2018 10:50
by MaximG
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.