Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Edinburgh Scotland

    Question Unanswered: Ingres long varchar - BLOBS

    Dear All

    Does anyone know a way to get 100,00 character long text string into a long varchar field without splitting the line into 50 x 2000 long varvhar strings and concatting those together ? I dont know if this would even work as the maximum page size I can have is 64k and it looks like I need 96k. Import Assistant tells me the lines are too long !!

    All help greatly appreciated.


  2. #2
    Join Date
    Jul 2003
    You could try the long varchar type - although this may only be available in newer releases of Ingres.

    although (and I quote from the on-line documentation for 2.6) ...

    "A string literal of more than 2000 characters cannot be assigned to a long varchar column. Details about assigning long strings to these columns are found in the description of data handlers in your host language companion guide or the OpenAPI User Guide."

    If you have access to the OpenAPI User Guide, then that may give you the answer.

Posting Permissions

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