Facing mapping issues with Unicode fields. Have one SQL Server intelligent db adapter running. And the input document contains all Unicode string fields irrespective of the real data type in table.
Case 1: Mapping the input document to a configured insert operation template. The insert operation takes the column data type from table which could not be changed for inputs. Unicode string to the respective real data type to the table. Mapping fails when mapping a date value from Unicode to datetime type, and inserts null values in table.
Case 2: Mapping input document to a configured Custom SQL operation template. In custom SQL all inputs are default created as Unicode which could not be changed. Now the mapping is from Unicode (input document) to Unicode (Resource operation). But the all fields are mapped as constants that is if the value is ‘XYZ’ value, it is mapped as XYZ. So the insert fails as no literal constants allowed to insert in a string field. Tried to use :v as a place holder, then the values are become ? for each field.
If anybody faced this issue already please share your thoughts.