Can you create a temporary table (as a staging table) with the datatypes you want? You could insert the incoming data into desirable covariant data columns. From there you could manipulate the data as you want.