PrismaP
Prisma5mo ago
2 replies
joel.rainearwills

TypedSQL - Boolean Argument Documentation

According to the docs, boolean values are converted to TINYINT(1) in MySQL, https://www.prisma.io/docs/orm/overview/databases/mysql#native-type-mapping-from-prisma-orm-to-mysql. However, TypedSQL converts boolean js values to strings, like 'true' and 'false'. This leads to consternation when trying to craft where clauses.
This page explains how Prisma can connect to a MySQL or MariaDB database using the MySQL database connector.
MySQL database connector | Prisma Documentation
Was this page helpful?