sql server - varchar(max) fields displayed as CLOB

Note: please leave bug reports and feature requests on

sql server - varchar(max) fields displayed as CLOB

Postby antonmos » Tue Jan 27, 2015 9:17 pm

wanted to share this workaround.

When querying a SQL Server table with field that is defined as just varchar (without specific size), dbeaver would render the fields as "CLOB", which made it very hard to use.

The workaround is to configure the jTDS driver to not use LOBs as follows:
* from connection dialog, click 'edit driver'
* on 'connection properties', right click the grid and 'add property'
* enter 'useLOBs' for name and 'true' for value

Perhaps, this should be the default? not sure what the implications are for real LOB fields.
Posts: 11
Joined: Tue Jan 27, 2015 8:58 pm

Return to Support

Who is online

Users browsing this forum: No registered users and 12 guests