ISQL - exporting column with very long text
<p>I have a table in sybase database running on Solaris, which I like to export. The table contains a column which is of IMAGE type and it contains very long text ( 100000+ chars). I'm not able to export it properly, because isql splits the lines in the output.</p>

<p>So far I've been trying with <code>-w</code> option in isql command line and also with textsize option within SQL, but no success so far.</p>

<p>I used isql with <code>-o &lt;filename&gt;</code> option to store query results in the file. I also tried </p>

<p>SELECT * from tablename OUTPUT TO "filename"</p>

<p>but this doesn't work for me.</p>

<p>Is there any hidden limitation of column width in isql or maybe some other display/screen/output settings which need to be adjusted ?
Or is there maybe a way to compress that column, so its not that long ?</p>