Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    4

    Unanswered: change varchar2 data type ?

    hi,

    i'm having problems pulling data back from oracle via asp.

    the data is basic text and was stored as a varchar2 but i need something that can hold over the 4000 character limit.

    can anyone recommend a more suitable data type ?

    i'm having real problems with the page timing out since i've changed the data type to long.

    any help gratefully received ...

    c

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    clobs are the recommended way, avoid longs cos oracle are trying to get rid of them.

    You may however have to do some optimisation to get good performance.

  3. #3
    Join Date
    Jun 2003
    Posts
    4
    Thanks Alan,

    I was aware that the long datatype is no longer supported but wasn't sure if the odbc driver i'm using supports clobs whereas it does support longs.

    There seems to be a huge performance difference between a varchar2(4000 chars ?) and a long (2 gig storage ?) and I can only imagine that this will increase if I manage to get the code working with a clob.

    I'm surprised that I have to jump from a 4000 character-length data type to a clob with no inbetween data type available.

    c

Posting Permissions

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