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

Thread: Store more than 4000 characters in a datatype

  1. #1
    Join Date
    Feb 2004
    Location
    Mumbai, Maharastra
    Posts
    67

    Store more than 4000 characters in a datatype

    In a procedure i am trying to store character data more than 4000 characters. Since, varchar2 doesnt allow more than 4000 bytes. What can be other probable solutions. Tried using CLOB but could get the desired results.
    Regards,
    Surajit K Mitra

  2. #2
    Join Date
    Feb 2005
    Posts
    158
    In a procedure, a varchar2 can have a bit over 32000 characters.
    As a database column, you can use either a CLOB (normally best), LONG (there's various restrictions on using LONGs and I don't know of any good reasons for using them), or multiple VARCHAR2 columns [eg if you know it will never be more than 8000 characters, you can use two varchar2(4000)].

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