IMAGE vs TEXT using Sybase storage difference

From: Anima (animag00_at_aol.com)
Date: 06/25/04

  • Next message: Michael Peppler: "Re: IMAGE vs TEXT using Sybase storage difference" 
    Date: Fri, 25 Jun 2004 11:30:13 -0700
To: dbi-users@perl.org

    Hi,

    I am using Syabse::DBD 1.02. Currently we are storing images and text
    files in a Sybase TEXT column after converting to Hexadecimal. The data
    is doubled in storage size due to the conversion. We are having db space
    issues due to that.

    I am trying to explore other alternatives. My question is, if I use
    IMAGE datatype in SYBASE to store the text/image files instead of TEXT -
    which DBD::Sybase version do I need to use? Also will that give me any
    space benefit improvement - since the data stored in the IMAGE column in
    Sybase is still in hexadecimal (correct me if I am assuming something
    wrong here).

    Thanks,

    Anima.

  • Next message: Michael Peppler: "Re: IMAGE vs TEXT using Sybase storage difference"

    Relevant Pages

    • Re: Data Conversion into Sybase
      ... I would try to save the Excel files as *.csv file. ... Sybase should be able to< ... "jagluski" schrieb im Newsbeitrag ... We've thought about converting the data into MS Access ...
      (microsoft.public.excel.misc)
    • Numeric precision conversion : truncation instead of rounding
      ... I'm working in a project of converting an application from Syabse to ... Oracle. ... In Sybase, the result of convert,1.2378) is 1.23 ... Of course I can use truncate function ...
      (comp.databases.oracle.misc)