sql server - How to handle a line break in SQL and Python to appropriately return all lines?

Question

A string with a line break, e.g. first line here[linebreak]NEXT ONE is entered in a GUI-tool and read into an SQL server database where it appears to be a one line string, i.e. first line here NEXT ONE. However, if this field is read by Python, it is returned as NEXT ONEne here. It seems that the line break is registered somehow, but the handling is wrong as both lines are written on the same line. How to handle the line break in this chain GUI-SQL-Python to appropriately return both lines?

Answer 1

In case that you use MySQL you can use the escape_string method of mysqldb: https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-escape-string.html

This will escape the new line character (e.g. ) before storing it into your database.

Consider using a debugger (e.g.pdb or pudb) to examin the string you store into and the one you receive from the database.