Hi,
I joined 2 tables as below, the datatype is varchar and text.
select columnA, columnB from tableA
union
select columnA, columnB from tableB
However, I noticed that in scriptcase, it shows sql type is BLOB? I select the data type of the fields to “Text” but the sql type still shows BLOB?
I cannot put this field into quick search field since it is BLOB I guess. Can anyone kindly help as I need to let users to quick search on those fields.