Skip to Content

Convet blob datatype into varchar in BODS 4.2

Hi Experts,

Please let me know how to convert Blob datatype into varchar

Thanks,Murali

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Jan 16, 2017 at 02:11 PM

    For more details refer Data Services Reference Guide. You can define the column as BLOB in data services.

    Regards

    Arun Sasi

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 18, 2017 at 05:56 AM

    Hi Arun,

    Thanks for your reply.

    What is the alternate way to convert BLOB datatype into varchar or any other datatype In Sap BODS.

    actually, in our source sql server datatype was in GUID but while import table in DS, it is showing BLOB.

    Please guide me anyone how to reslove this issue.

    Thanks,Murali

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 18, 2017 at 12:50 PM

    You need to convert the BLOB column to varchar using a function.

    http://stackoverflow.com/questions/16222343/convert-guid-to-varchar32

    I have never tried this before so you need to play with the cast function. If the conversion works in SQL Server then it should also work in Data Services

    Regards

    Arun Sasi

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 22, 2017 at 06:22 PM

    Hi Murali,

    Right click on data store--->edit---->advanced---->check "import unsupported datatypes as varchar"

    Now in data store right click on the table that has blob data type column and change the data type from blob to varchar in table schema only.

    Thanks,

    Ravi kiran.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 07 at 12:56 PM

    Hi Ravi,

    I tried the above option but it's not working.

    Thanks,

    Harish

    Add comment
    10|10000 characters needed characters exceeded