DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Change Clob To ????

  1. #1
    Join Date
    Sep 2002
    Posts
    411

    Change Clob To ????

    Hi all,

    I have a table and this table had 20 columns, there were 5 columns that had datatype is CLOB and this won't work for our web application. What is the datatype should I change it to ??? One column had more than 5000 characters and the other 4 I can user VARCHAR2.

    Please help

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Ur problem, i gess, not in type of a column.
    U have problem in client side of application.

    What web application server u are using?
    What language and driver is using?

    U have to find decision on client side.

    We have many applications with CLOB/BLOB fields in web envifonment,
    and we haven't any problems with this type of field.

  3. #3
    Join Date
    Sep 2002
    Posts
    411
    I read somewhere before and from what I understand that CLOB will degrade performance of your database.

    Is that right to say ???

  4. #4
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Originally posted by mike2000
    I read somewhere before and from what I understand that CLOB will degrade performance of your database.
    I've never seen that CLOB itself degrades performance.
    Application using CLOBs in an improper way could do that, though.
    Ales
    The whole difference between a little boy and an adult man is the price of toys

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width