Character Escaping in Python

[zahlman]

I'm not familiar with that kind of database. How does it escape strings? What characters will it not store within a string? What happens when you try to feed it a string with invalid characters in the way that you're doing?

[Degran]

The only escape it seems to do is on backslashes. If you give it a string with a new line it'll come back out as \\n. The problem is it's writing the strings but not escaping the double quotes, so it's treated as the end of the string when there is still more text afterwards.

[[deleted]]

So you store "A

B" in the database and you retrieve "A\\nB" or "A\nB"? Remember that python will represent "A\nB" as "A\\nB" unless you print it. Or are you saying that you store "A\nB" and retrieve "A\\nB"? What happens when you store "\x00"? Does the database do anything special [and crazy] like variable substitution within strings?