sqlite查询用合法的回车替换隐藏/不可见的回车

I have an sqlite database with thousands of text entries. The text has many invisible/hidden carriage returns which shows the text in one long line. It displays okay on some programs, and on others it does not like this. If I just delete these hidden carriage returns and replace them by hitting the 'enter' button, everything works just fine. My question is how do I replace these hidden characters (which I believe are CHAR(13) or CHAR(10)) with a normal carriage return like I hit the enter button. What would the correct SQLite query be? I've found of examples about just replacing them all with an empty space but nothing about replacing with a normal paragraph. I have an sqlite database with thousands of tex