This is great, full support for native types has been added in prisma/prisma@v2.15.0!

For example, setting price with two decimal places:

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["nativeTypes"]
}
model Product {
  name   String
  price  Decimal?  @mysql.Decimal(10, 2)
}

Note that this would now return a Decimal (not native number):

const product = prisma.product.findFirst();
const price = product.price; // This is a `Decimal`, so you should typecast it
const discountedPrice = product.price.toNumber() * 0.9;

You could just use Float instead (which actually uses double precision in most providers). If you need more precision you should learn how to use Decimal.js which is what Prisma uses to process decimals like you are currently using. I'm not sure how it works, but I'd imagine that s and e (sign and exponent?) are important and should not be ignored.

Full support for native types has been added in prisma/[email protected]

datasource db {
  provider = "mysql"
  url      = env("DATABASE_URL")
}

generator client {
  provider = "prisma-client-js"
}
 
model Product {
  id Int @id @default(autoincrement())
  code String
  price Decimal @db.Decimal(9,2)
}

This is the GitHub repository for Prisma 2. For Prisma 1 questions you should probably ask at https://github.com/prisma/prisma1

It looks like the type you should use is called Int. I'm getting that from this Prisma documentation listing the different field types. The field types available are:

• String
• Boolean
• Int
• BigInt
• Float
• Decimal
• DateTime
• Json
• Bytes
• Unsupported

The only way to accomplish something like this that I could see is to use String as the type within Prisma schema and within your code consume the values by parsing them into floats again / stringifying them.

This way you could use string operators within Prisma, so for example { floatAsString: { contains: '36' } } would find 360 and 23.36

If you keep it as floats in the Prisma schema there are no operators to achieve this in the Prisma API.