#11 Support for Clobs

General
closed
Colin Bell
General (118)
5
2004-04-27
2002-02-20
Anonymous
No

I am unable to view CLOB/Blob data types for oracle
through the SQL Client 1.1 beta. It just
says "<Unknown>". Please consider adding support for
these data types..

Discussion

  • Logged In: YES
    user_id=379231

    i don't think that showing blobs are very usefull
    but i believe that clobs (longvarchar?) is displayed now.

    Please tell me what java.sql.Types.XXXXX it is that is a
    clob and that you want to display.

    If 1.1beta2 is out please try it again.

     
  • Colin Bell
    Colin Bell
    2002-05-17

    • assigned_to: nobody --> colbell
     
  • Colin Bell
    Colin Bell
    2002-05-17

    Logged In: YES
    user_id=233132

    One of the things I am thinking of for the future would be
    trying to display images etc. that are stored in blob columns.

    Col

     
  • Logged In: YES
    user_id=379231

    how do you know if it is an image?

     
  • Colin Bell
    Colin Bell
    2002-05-20

    Logged In: YES
    user_id=233132

    I was thinking of a dropdown with "View as image", etc. in
    it. Need to be able to register new viewers as well.

     
  • Colin Bell
    Colin Bell
    2002-07-16

    Logged In: YES
    user_id=233132

    1.1beta5 will show binary, varbinary, longvarbinary, clob
    and blob as text if requested.

     
  • Jerry Haltom
    Jerry Haltom
    2004-02-09

    Logged In: YES
    user_id=689036

    What about setting Clobs/Images? Just let the user select a
    local file to "upload" into it. That covers pretty much any
    case.

     
  • Colin Bell
    Colin Bell
    2004-04-27

    Logged In: YES
    user_id=233132

    Clob support is now reasonably mature in 1.2beta5.

     
  • Colin Bell
    Colin Bell
    2004-04-27

    • status: open --> closed