Python-data Truncated And Spaces Are Added Between Data While Inserting Into Mssql

Upon inserting the data into the MS SQL Server DB, my values are getting truncated and single extra space is added in between. For eg:- HomeShop18 is saved as H o m e s. It is trun

Solution 1:

Be careful of the order of parameters. It seems 'Height' and 'Width' are inverted in the query and in the parameters.

Check if the order of your parameters in execute() is the same as

(AWB_Number,Weight,Length,Width,Height,Customer_Name,Scan_Time,Series_Flag)