Hi. I am using mySql. I have a column of type blob (since what I want to do requires a string larger then varchar can handle).

I'm not quite sure how I can get the information from this column and display it as a string so that it is displayed on a web page.

I see that there is a getBlob method in resultSet and then in java.sql.blob there is a getBinaryStream method. Is this what I need to use? Is there no way to get the blob and just do a toString()? Using a stream seems more complicated then it should be.

I am just trying to make a guestbook and this is for the comment field... so it doesn't need to be ridicuously big.

Any help would be greatly appreciated.