1 reply

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(sql

SELECT * FROM table

SELECT * FROM table

)

Drizzle Team•2y ago•

1 reply

blinkblinko

Missing newlines when querying sqlite text column

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(sql

SELECT * FROM table

SELECT * FROM table

)

Missing newlines when querying sqlite text column

Similar Threads

Missing newlines when querying sqlite text column

Similar Threads

Similar Threads

Similar Threads