select on varchar(max) returns (Long Object)

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
RM-RQ
Posts: 1
Joined: Thu 05 Apr 2018 18:42

select on varchar(max) returns (Long Object)

Post by RM-RQ » Thu 05 Apr 2018 18:52

Hello
Using dbForge Query Builder for SQL Server (Standard edtion version 3.9.163 OS Version: Windows 7 X32)

When running a query in "Results as Text" mode on "varchar(max)" columns, "(Long Object)" is returned.
For instance:
SELECT top 1 DS_DON_COM_REF_ALL from JA1.DONCREF;
DS_DON_COM_REF_ALL
------------------
(Long Object)
1 records fetched

When running the same query in "Results as Grid" mode, the data is displayed properly.

I've ran the same query on other database products (SSMS 2012 server) and the the data is properly returned when running in "Results as Text" mode

I cannot use "Results as grid" mode since we use an automated tool which scan text results from multiple queries.

Any help would be... helpful !

Thanks!

alexa

Re: select on varchar(max) returns (Long Object)

Post by alexa » Fri 06 Apr 2018 06:21

We will investigate this issue and will answer you as soon as possible.

Post Reply