Skip to content

Support Json in SQL Server #7417

@matthewmueller

Description

@matthewmueller

Problem

If you have the following Prisma Schema:

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "sqlserver"
  url      = env("DATABASE_URL")
}

model Post {
  id      Int  @id
  myField Json
}

You'll see the following message:

error: Error validating field `myField` in model `Post`: Field `myField` in model `Post` can't be of type Json. The current connector does not support the Json type.

Suggested solution

Support Json in MSSQL

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions