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

Snapshot
open
nobody
None
3
2015-01-08
2014-03-20
Nick
No

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.

2 Attachments

Discussion

  • Nick

    Nick - 2014-03-24

    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

    Conrad - 2014-11-03

    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

    Nick - 2014-11-03

    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

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks