Title
n

Nathaniel Bajo

02/01/2022, 9:57 AM
Native type VarChar is not supported for sqlite connector. Does anyone know any native type that is supported by sqlite connector ??
n

nikolasburk

02/01/2022, 10:43 AM
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 🙂
n

Nathaniel Bajo

02/01/2022, 10:53 AM
Oh I see
🙌 1
Thanks.
n

nikolasburk

02/01/2022, 10:58 AM
No problem 🙂 FWIW, this is quite confusing so I created an issue to better document this: https://github.com/prisma/docs/issues/2803
n

Nathaniel Bajo

02/01/2022, 11:04 AM
Alright cool.