Drizzle TeamDT
Drizzle Team•2y ago
blinkblinko

Missing newlines when querying sqlite text column

I am saving text to a turso sqlite database, if I shell into the db I can see that the newlines have been saved, but whenever I use drizzle orm db.query.table.findMany() I see that the newlines have been stripped. Any idea how to stop this?

For example, using the db shell:
SELECT * FROM table;
ID              TEXT
0               Hello
                World
1               Single line
2               Newline

                are

                preserved
3               Another single line


But using drizzle:
await db.query.table.findMany();
[
  {
    id: 0,
    text: "Hello world"
  },
  {
    id: 1,
    text: "Single line"
  },
  {
    id: 2,
    text: "Newline are preserved"
  },
  {
    id: 3,
    text: "Another single line"
  },
]


Its the same if I use db.run(sqlSELECT * FROM table)
Was this page helpful?