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
As a temporary workaround, I can do
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!" to the database and then query it, it comes back with all \ns escaped.As a temporary workaround, I can do
.replaceAll("\\n", "\n") on every string, but that doesn't seem like the ideal option.