Foxhound is the better* Database Monitor for SQL Anywhere.
*better: More thorough, more relevant, more effective.
...more Alerts, more All Clears, more details, more control in your hands.


Breck Carter
Last modified: April 30, 1996
mail to: bcarter@bcarter.com



Casting BLObs

The Watcom SQL cast function can be used to convert a long binary (BLOb or "Binary Large Object") column to char (string) format. This is helpful when a BLOb column is sometimes used to store binary data, and sometimes string data, and you need to show the string data in a PowerBuilder DataWindow.

It's a lot easier to code

   select cast ( column_name as char ) from table_name

than it is to call SelectBlob().


See also: User-Defined SQL Functions and Timeless Dates

Breck Carter can be reached by phone at (416) 763-5200 or via email at bcarter@bcarter.com.