| Nikolai 2004-04-15, 1:37 am |
| Does anyone know how to force the updategram generated by the SQL adapter to not treat image data types as nvarchar?
I have a table with one SQL image column that is storing Binary data. I am converting the binary data to string and attempting to add it but always get 'Operand type clash: nvarchar is incompatible with image'
I have seen that SQLXML3.0 and the Biztalk Help has the concept of a mapping-schema (ms-help://BTS_2004/Operations/htm/ebiz_prog_adapt_nsob.htm). It states "include the schema-mapping attribute on the sync element of the updategram document instance". Whi
ch I have done, but it seems to ignore the schema and generates the updates with all nvarchar i.e.
INSERT F986113 (SSSRVBLOBA) VALUES (N'0x30303034302C3231303532312C5338')
Has anyone tried to use mapping schemas? Am I wasting my time on this tact?
|