opaldraggy
DTDrizzle Team
•Created by opaldraggy on 10/27/2024 in #help
Json column type returning as plain string?
I have a schema for a json column (sqlite, proxy http driver) defined as:
authors: text({ mode: 'json' }).notNull().$type<string[]>(),; and I'm able to save data into it by passing an array of strings: ['Mary Shelley']. However, when I run a select on that schema, I get back a string of the json: "[\"Mary Shelley\"]". Curious if that's expected, and/or if there is a way to automatically parse the resulting json.
The type information for authors is showing up correctly as string[]. But the data is a plain string.6 replies