Hello,

            I am using Sybase ASA V7.03 using a servlet with JDK1.3 (6/2/2000).  This servlet has been in production for over a year and I just found that if I am grabbing a resultset that has a long varchar (BLOB) with only 1 char in the field, I get back no data.  If the field has 2 chars or more, then no problem, but 1 char returns no data.  Regular char and varchar fields seem to work fine.

            The code is pretty simple:

 

for(int col=1;col <= NumColumns; col++)

  try {

    String data = "Result.getString(col);

// data is empty string here under conditions stated above

  ColumnDataHash.put(ColumnNames[col - 1].toLowerCase(),data);

 } catch(Exception e) {

  // error stuff here

 }

 

Anyone seen anything like this?

Thanks,

Chuck

Reply via email to