How to store/query multi-line text in database?

Hey there!
I'm currently having some problems storing (or querying; actually not quite sure where the problem lies) multi-line texts in my MySQL database using Drizzle.

When I use drizzle or drizzle studio to write a string like

"Hello\nWorld!"

"Hello\nWorld!"

to the database and then query it, it comes back with all

\n

\n

s escaped.

As a temporary workaround, I can do

.replaceAll("\\n", "\n")

.replaceAll("\\n", "\n")

on every string, but that doesn't seem like the ideal option.

Angelelz•11/28/24, 12:31 AM

How are you trying to view the string? It might be what you’re using to render it.

Angelelz•11/28/24, 12:31 AM

I find it hard to believe that the replaceAll is actually doing anything

AAngelelz How are you trying to view the string? It might be what you’re using to render i...

CRUGGOP•11/28/24, 1:03 AM

console.log

console.log

and using the library. When provided with directly, console.log logs with the newlines and yaml works. When writing, then querying and using the same string through Drizzle, console.log logs

\n

\n

literally and yaml library throws an exception (since yaml is dependant on newlines)
And if I run the replaceAll on the result from Drizzle, it all behaves as before again.

Angelelz•11/28/24, 1:06 AM

Ohhh, sorry I didn’t notice the two back slashes in the first one

Angelelz•11/28/24, 1:08 AM

Can I see how are you inserting the values on the db?

CRUGGOP•11/28/24, 1:12 AM

I also tried:

both with the same result.

Angelelz•11/28/24, 2:21 PM

Interesting, I looked into drizzle code and didn’t find anything in drizzle escaping the back slashes

Angelelz•11/28/24, 2:21 PM

You should test the mysql2 driver directly and see if it has the same behavior