Hello, what is the best way to overcome `text` col...
# orm-help
s
Hello, what is the best way to overcome
text
column length limits? Prisma seems to set it to 191, without any way to specify in the schema, and I need much longer for some columns.
e
Hello @Shane, Later versions of Prisma ( I think v2.16+ ? ) allows you to map to native table types: https://www.prisma.io/docs/concepts/components/prisma-migrate/type-mapping The doc shows example for VARCHAR, you can also map it to TEXT like this:
Copy code
model Something {
  id                Int      @id @default(autoincrement())
  longText          String   @db.Text
}
plus one +1 2
🤩 1
s
Hi @Eddy Nguyen -- thank you so much, I don't know how I missed this! I spent a lot of time reading forums/threads. This news makes my day 😄