Wednesday, 18 December 2013

SQuirreL SQL Client show CLOB field.

SQuirreL SQL Client show CLOB field 

This is the default setting for BLOB/CLOB types. It allows SQuirreL to load the more commonly used data faster. You can change this by going to File -> Global Preferences -> Data Type Controls, and scroll down in the Global Preferences window until you see settings for BLOB and CLOB types. There you would select the checkbox next to "Read contents when table is first loaded". Alternatively, it may also be possible to double-click on the cell that contains
"<Clob>" value to see a separate window with the data displayed.