#1139 Columns "NVARCHAR2" from Oracle DB are shown as "Other" instead of the real content

[Nick]

In the last couple of snapshots I have found that the columns of type "NVARCHAR2" from the Oracle DB are shown as "< Other >" in the "Content tab" (data preview) of the Database Object Tree.
I have attached a couple of screenshots to explain the issue.

Instead, if I run a select in the SQL editor, the real content is correctly shown.

[Nick]

I have just installed the last stable version 3.5.2, and this issue is present also here.
The last stable version without this problem was the 3.5.0.

[Conrad]

Hi Nick
I had a similar problem (using 3.6.0 rc2 and 3.5.2) and discovered that if I check the option "Read contents when table is first loaded and display as string" under "SQL Other (SQL type 1111)" on the "Data Type Controls" tab of "Global Preferences" under the "File" menu it started working. Not sure why this option got changed (I certainly did not change it), or if the issue is caused by something else and this is a work around, but thought I'd mention it.

[Nick]

Hi Conrad,

thank you for the hint. We will see, or perhaps someone other will tell us, if this is a work around or not :-)

Regards

[Ben Davies]

this answer worked for me..
https://stackoverflow.com/questions/35557670/squirrel-sql-client-does-not-show-json-data

Under the following two sections:

Global Preferences > Data Type Controls > SQL Other (SQL type 1111)
Global Preferences > Data Type Controls > Unknown DataTypes (non-standard SQL type codes)

you should check the checkboxes saying

[X] Read contents when table is first loaded and display as string