Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

When do I want to use Powerscripts BLOB datatype?

April 26, 2017blob datatype powerscript

0

Posted

When do I want to use Powerscripts BLOB datatype?

1 Answer

0

Posted

There are several reason’s why you would want to use the BLOB datatype. For Example: · You need to store OLE objects in your database · You need to store large binary objects in your database · You are storing text larger than that easily handled by normal functions · You need to access a variable type that PowerBuilder does not support. For example, in SQLBase the longvarchar datatype is not a supported datatype, but can be manipulated through use of blob functions. What datatype on my DBMS can work as BLOB in Powerscript? It’s best to consult your database documentation, as well as the Appendix of your PowerBuilder database interface guide to determine this. Listed below are some supported databases and the corresponding datatypes. DBMS Datatypes ASA (SQLAnyWhere) long binary, long varchar Oracle longraw SQL Server Image, Text Informix Text MDI Gateway DB/2 Long varchar SQLBase longvarchar AllBase longvarchar DB2/2 N/A I. OLE columns – DataWindows only: Before creating on OLE column