CLOB-Values are not displayed correctly for MS-SQL-Server

[Tobias Twardon]

We are using JIRA on MS-SQL Server.

When having CLOB-Values in the tables, they do not display correctly:

That's a sample-query for a standard-table

SELECT top 10 * FROM "fieldconfiguration"

When changing the query as follows the contents do display correctly:

SELECT top 10 fc.id,configname,substring(description,1,1024) as description, fieldid,customfield  FROM "fieldconfiguration" fc

[Renjith Pillai]

Feel free to send a pull request if you are aware of the fix. These days I am not spending that much time in maintaining this.

[Holger Lehmann [catworkx GmbH]]

I have seen the same for Oracle.

While I am not sure that I want to auto convert everything to varchar right away, since the resulting data to display may become quite large, e.g. jiraworkflows.descriptor …

A simple “help” text would be sufficient “for me” about how to convert the BLOB/CLOB columns into something readable using SQL statements.

This essentially takes the load off of the Jira (Java) server and would enable the user to only retrieve and view the “really” required amount of data.

Would do you think?

[Renjith Pillai]

Isn’t that something that should be referred in the DB documentation? The plugin is practically unaware of the underlying type of database.

[Holger Lehmann [catworkx GmbH]]

True, but

1. since we (as of now) know, that only MSSQL and Oracle “behave” that way
2. and every second user keeps asking this question
3. and I have to look up the proper “convert” call in the documentation

I thought it might be just a nice touch to give the users a “Hint”, nothing sophisticated …

Just my 2ct