Drizzle Team•5mo ago

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

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"
  },
]

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)

1 Reply

blinkblinkoOP•5mo ago

Actually this looks like a libsql client issue to me. Using the underlying db client is returning the same, without preserved newlines

Gaming

Programming

Missing newlines when querying sqlite text column