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.
HTH
antonmos
 
Posts: 11
Joined: Tue Jan 27, 2015 8:58 pm

Return to Support



Who is online

Users browsing this forum: Google [Bot] and 9 guests