Portlet Factory, Version 6.1.2


 

About working with BINARY and VARBINARY results

Some database columns are stored as binary fields even though the data they represent is simple strings. BINARY and VARBINARY are SQL types that SQL Transform will automatically attempt to convert into strings. This approach may or may not work, depending upon the content of the columns and the actual data. If you expect BINARY or VARBINARY results to be returned, keep in mind that these results will be converted into strings. If that is not appropriate for the data involved, you will need to add a custom transform for those columns.

Parent topic: SQL Call builder


Library | Support |