Skip to Content
0

Convet blob datatype into varchar in BODS 4.2

Jan 16, 2017 at 08:51 AM

549

avatar image

Hi Experts,

Please let me know how to convert Blob datatype into varchar

Thanks,Murali

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Arun Sasi Jan 16, 2017 at 02:11 PM
0

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

Regards

Arun Sasi


cbdqy.png (27.8 kB)
Share
10 |10000 characters needed characters left characters exceeded
Murali Krishna Jan 18, 2017 at 05:56 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Arun Sasi Jan 18, 2017 at 12:50 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Ravi kiran Pagidi Jan 22, 2017 at 06:22 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded