What native types are supported by the SQLite connector in Prisma?

Native type VarChar is not supported for sqlite connector. Does anyone know any native type that is supported by sqlite connector ??

Hey Nathaniel 👋 there are no native type mappings for SQLite because SQLite doesn’t have any types that aren’t already covered by the Prisma scalars. Note that if you declare a

VARCHAR

with a certain length in SQLite, it will get ignored and the type of the column will just be

TEXT

(that’s documented in the SQLite docs here). So, in that case, declaring a

String

type in Prisma has the exact same effect. Hope this helps 🙂

Oh I see

No problem 🙂 FWIW, this is quite confusing so I created an issue to better document this: https://github.com/prisma/docs/issues/2803

Alright cool.