Topic
  • 5 replies
  • Latest Post - ‏2007-03-15T22:54:06Z by Stan
SystemAdmin
SystemAdmin
1525 Posts

Pinned topic Clarification needed on LONG VARCHAR and CLOB

‏2007-03-15T21:25:24Z |
Are they essentially the same? Its seems they both have a character limit of 2GB.

Thanks in advance for your help.
Updated on 2007-03-15T22:54:06Z at 2007-03-15T22:54:06Z by Stan
  • Stan
    Stan
    267 Posts

    Re: Clarification needed on LONG VARCHAR and CLOB

    ‏2007-03-15T21:56:21Z  
    From the current Reference Guide:
    The LONG VARCHAR type allows storage of character strings with a maximum length of
    32,700 characters. It is identical to VARCHAR, except that you do not have to specify a maximum length when creating columns of this type.

    Where did you see the limit listed as 2Gb?
  • SystemAdmin
    SystemAdmin
    1525 Posts

    Re: Clarification needed on LONG VARCHAR and CLOB

    ‏2007-03-15T22:00:54Z  
    • Stan
    • ‏2007-03-15T21:56:21Z
    From the current Reference Guide:
    The LONG VARCHAR type allows storage of character strings with a maximum length of
    32,700 characters. It is identical to VARCHAR, except that you do not have to specify a maximum length when creating columns of this type.

    Where did you see the limit listed as 2Gb?
    I must be looking at an old reference manual which says:

    "The LONG VARCHAR type allows storage of character strings of unlimited length."

    its dated 11/21/2004, which is probably too old. Or did LONG VARCHAR used to allow unlimited?
  • Stan
    Stan
    267 Posts

    Re: Clarification needed on LONG VARCHAR and CLOB

    ‏2007-03-15T22:22:00Z  
    I must be looking at an old reference manual which says:

    "The LONG VARCHAR type allows storage of character strings of unlimited length."

    its dated 11/21/2004, which is probably too old. Or did LONG VARCHAR used to allow unlimited?
    You are probably looking at a manual for Cloudscape (an IBM licensed product) not IBM Cloudscape (open-source, based on Derby). I don't believe the two datatypes were identical in Cloudscape. In even older versions of Cloudscape I believe varchar was unlimited.

    There are many differences between the two products. If you are just gettting started I recommend using Derby rather than Cloudscape or IBM Cloudscape. Please see the recent notice regarding the withdrawl of IBM Cloudscape:

    http://www-1.ibm.com/support/docview.wss?rs=636&uid=swg21256502
  • SystemAdmin
    SystemAdmin
    1525 Posts

    Re: Clarification needed on LONG VARCHAR and CLOB

    ‏2007-03-15T22:31:06Z  
    • Stan
    • ‏2007-03-15T22:22:00Z
    You are probably looking at a manual for Cloudscape (an IBM licensed product) not IBM Cloudscape (open-source, based on Derby). I don't believe the two datatypes were identical in Cloudscape. In even older versions of Cloudscape I believe varchar was unlimited.

    There are many differences between the two products. If you are just gettting started I recommend using Derby rather than Cloudscape or IBM Cloudscape. Please see the recent notice regarding the withdrawl of IBM Cloudscape:

    http://www-1.ibm.com/support/docview.wss?rs=636&uid=swg21256502
    Thanks Stan.

    No, it is an old version of Derby, one of the first that I downloaded in October 2004 from apache. I am still using databases from that timeframe, so maybe LONG VARCHARS in my version (10.0.2.1) are unlimited. I will have to do some testing.

    Thanks for your help.
  • Stan
    Stan
    267 Posts

    Re: Clarification needed on LONG VARCHAR and CLOB

    ‏2007-03-15T22:54:06Z  
    The manual for that release is incorrect and was subsequently corrected.