Data type from mssql to mysql

modara — Fri, 15 Nov 2024 22:33:19 GMT

hi,

I am trying to take data form MSSQL to MYSQL using simple data transfer

my data type is as per following picturehere SQTY is BIG Decimal and Decimal and length is 15 and precesion is 6 for both mssql and mysel

for other column (example: Net_amt, Return_QTY) i dont get any issue when take data from mssql to mysql.

They are same as this SQTY column (BIg Deciman and Deciman lenght 15 and precision 6)

but for this SQTY column i am having issue

in MSSQLi have following value

after data taken from MSSQL to MYSQL same column SQTY

in mysql i have following value

please help me out what i should do

Re: Data type from mssql to mysql

modara — Thu, 15 Sep 2022 05:37:48 GMT

hi,

I attached a mysql query where sqty before decimal not picking more than 3 digits

but with same Decimal configuration decimal (15,6) it takes 6 digits (example: Net_amt, Sub_total column)

i really need help for this issue. my report showing me incorrect information as this is sale quantity. what i should do please help. here i attached column for understanding.

topic Re: Data type from mssql to mysql in Data Quality

Data type from mssql to mysql

Re: Data type from mssql to mysql