SQlite replace '\n' to newline

Question

I have \n in my database after importing from Mysql. How can I replace '\n' to be a real new line?

I tried

UPDATE table SET column = replace(column, '\n', "\n")

in several variations but without success.

similar question: [New Line character \n in SQLite concatenate](http://stackoverflow.com/questions/23930865/new-line-character-n-in-sqlite-concatenate) — CL., Jun 29 '14 at 07:59

score 2 · Answer 1 · answered Jun 29 '14 at 05:38

2

UPDATE cy_prod SET text = replace(text, '\n', '
')

made the trick

answered Jun 29 '14 at 05:38

Qiao

score 0 · Answer 2 · answered Mar 24 '22 at 10:26

0

Another option:

UPDATE table SET column = replace(column, '\n', char(10));

ASCII char code 10 is the UNIX newline character.

answered Mar 24 '22 at 10:26

oelna

2 Answers2