Results 1 to 2 of 2

Thread: Varchar

  1. #1
    Join Date
    Nov 2003
    Posts
    12

    Unanswered: Varchar

    I have a field in Table which is a data type of "VARCHAR 1000" but we can't insert anything more than 255 characters. So, does any one know what is up with this?

    Our Database is running on DB2 (v6.5) on OS/390.

    Thanks
    bjmp

  2. #2
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Use Diff Data Type

    Hi.

    I think that is way beyond the limit of the varchar datatype. Am not sure but I think the limit is 256 would be advisable to use a CLOB or a LOB for that.

    That's the way we've implemented it at our end.


    Nitin.

Posting Permissions

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