I'm trying to use BigDecimal where the value 12.00 should be different than 12.0 or 12, how do i handle it with sqlite?

Use text. As numbers (integer or real (floating point)) they are all the same value.

That is, to be precise, 12.00 == 12.0 == 12

The only way for SQLite to think them different is to format them appropriately and store them as text. Then you will find that ' 12.00 ' != ' 12.0 ' != ' 12 ', as long as the comparison is carried out in the text domain.

Note that each text field is formatted with up to 8 digits blank padded on the left forming the "integer part" of the text field, a decimal point ('.') if the number is to be considered a "decimal", followed by 8 digits of decimal part blank padded on the right. Converting the numbers to and fro however you are representing them on your appplication side and the text representation on the SQLite3 side is for you to figure out yourself.

If you do not require SQLite3 to compare the text representations, then you may represent them any way you like (as text) and any comparison or ordering is your problem to solve in your application.

NOTE Added single-ticks to make the text fields preserve blanks.

Note that the binary/text format you choose is your choice. If you are going to require SQLite3 to "compare" or "sort" them you will have to provide either a correct sortable formatting that does what you want, or provide your own "compare" functions. If you expect them to be sortable or comparable, you will need to provide your own collation function (and store the data as text so that collation applies).