Data truncation can occur when multiple parameter sequences are passed to executemany and the first sequence contains values that map to variable length SQL types. The width of the SQL type is determined by the values in the first sequence, so if these are shorter than values in subsequent parameter sequences to the values are truncated. This is due to the implementation of executemany, which uses sp_executesql internally and must declare the type of the parameter before the first execution.
Data truncation can occur when multiple parameter sequences are passed to
executemany
and the first sequence contains values that map to variable length SQL types. The width of the SQL type is determined by the values in the first sequence, so if these are shorter than values in subsequent parameter sequences to the values are truncated. This is due to the implementation ofexecutemany
, which usessp_executesql
internally and must declare the type of the parameter before the first execution.