Page 1 of 1

sql server - varchar(max) fields displayed as CLOB

PostPosted: Tue Jan 27, 2015 9:17 pm
by antonmos
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