[Answer]-Sqlite not saving decimals but works fine in MySQL

SQLite is very “democratic” and light-weight database. For example, you can declare VARCHAR(20) field and write 30-symbol string to it without any error or warning message.

From SQLite documentation:

A string might look like a floating-point literal with a decimal point and/or exponent notation but as long as the value can be expressed as an integer, the NUMERIC affinity will convert it into an integer. Hence, the string ‘3.0e+5’ is stored in a column with NUMERIC affinity as the integer 300000, not as the floating point value 300000.0.