docs icon indicating copy to clipboard operation
docs copied to clipboard

Consider qualifying the raw query data conversion types table

Open andrew-walford-prisma opened this issue 2 years ago • 0 comments

In this section of the raw database access doc, the table is perhaps too simple, because the details are not true for all database engines.

Flavian pointed out that there are small differences in the raw mapping type, depending on the database engine. For example, MariaDB stores JSON as a string, so it's coerced as a string on the JavaScript side. SqlLite always defaults to BigInt when there's no column information (e.g. with SELECT 1 + 1), unless there's a type case.

We might want to either add these exceptions to the table or add a qualification to the text above or below the table.

andrew-walford-prisma avatar Jun 21 '22 09:06 andrew-walford-prisma