I'm importing some data from the ERP to my local app.
ERP and my app are using MSSQL as DBMS.
One field (Name) is defined as nchar(20) in both tables.
I read one record using a query and insert it in destination table using a parametizer query:
qryDEST.ParamByName('NAME').AsWideString:=qryORI.FieldByName('NAME').AsWideString;
If the Name is a string composed only of one byte char all is fine.
If the Name contains 20 chars and one of them is a unicode char (example µ) I received the error from MSSQL: string binary will be truncated.
In Debug I see the right text.
Is it an error in my program or is it a limitation in ODBCConn?
Regards
Luca